🧠 AI Classification
Excalibur's Graph Neural Network instantly understands your data patterns. Privacy-preserving design means field names never leave your environment.
🛡️ Automatic Governance
Pridwen detects PII and recommends transformations like hash, mask, and encrypt. Day-1 intelligence that gets smarter with every customer.
🔄 Multi-Warehouse
One JSON source compiles to optimized SQL for BigQuery, Snowflake, Databricks, and Redshift. Write once, deploy anywhere.
One JSON Source → Four Optimized Warehouses
Forge transforms nested JSON into query-ready native structs—ready to traverse with dot notation.
60-90% cost savings on repeated queries vs parsing raw JSON
every time.
How is Forge Different?
Traditional ETL tools replicate structured data. Forge understands, governs, and transforms any data—with AI intelligence built in.
| Capability | Traditional ETL (Fivetran, Stitch) | Forge |
|---|---|---|
| JSON Handling | Loads raw JSON into a single `VARIANT` column. Requires manual parsing. | Automatically unnests nested objects and arrays into clean, queryable tables with proper keys. |
| Schema Intelligence | No understanding of data semantics. Schemas are just column names. | Excalibur GNN classifies data patterns (payment, customer, inventory) to enable smart defaults. |
| Data Governance | Manual PII detection. Compliance is your problem. | Pridwen automatically detects PII and recommends hash, mask, or encrypt transformations. |
| Multi-Warehouse | Separate connectors/config per warehouse. Limited dialect support. | One source → simultaneous output for BigQuery, Snowflake, Databricks, and Redshift with optimized SQL. |
| Schema Evolution | Pipelines break when fields change. Manual intervention required. | Automatically detects and adapts to schema changes—no downtime. (Llamrei coming Q2 2026) |
Focus on Analytics, Not Engineering
Building a robust JSON processing pipeline is a significant engineering effort. Here's how Forge accelerates your time to insight.
| Data Engineering Task | Manual Process (Time Estimate) | With Forge |
|---|---|---|
| Initial Schema Discovery | Write scripts to scan data, identify fields, and determine data types. (2-4 hours) | Automatic. Done in minutes during the first run. |
| Data Classification | Manually review schemas to understand data semantics. (1-2 hours) | Excalibur AI. Instant classification with 89% accuracy. |
| PII Detection & Governance | Security review, manual tagging, compliance documentation. (1-3 days) | Pridwen AI. Automatic detection and transformation recommendations. |
| Write Parsing & Unnesting Logic | Develop and debug complex SQL or Python code. (1-3 days) | Automatic. Forge handles all unnesting logic. |
| Total Time to Value | Days to Weeks | Under 15 Minutes |
Security & Compliance: Your Cloud, Your Rules
For organizations with strict data residency and security requirements, Forge Enterprise offers a unique deployment model that keeps you in control.
| Requirement | Traditional SaaS | Forge Enterprise |
|---|---|---|
| Data Location | Sent to vendor's cloud | Stays in YOUR cloud |
| AI/ML Privacy | Your data trains their models | Privacy-first: only structural fingerprints |
| Security Review Time | 3-6 months | 2-4 weeks |
| Works with PII/PHI | Requires extensive compliance | Yes, by architecture |
From Black Box to Glass Box: Complete Transparency
Forge isn't just a parser; it's a fully-managed, transparent data cataloging system with AI intelligence. Every run generates rich metadata that gives you unprecedented visibility.
Automatic dbt Docs
Forge uses dbt Core to power its transformations. After every run, it generates and hosts a full dbt documentation site for your project.
Complete Code Transparency
Ever wonder what a transformation tool is actually doing? With Forge, you can inspect the exact SQL code used to generate every table.
End-to-End Data Lineage
The generated dbt docs include a complete, interactive DAG showing how data flows from your raw JSON sources to the final tables.
Write Once, Deploy Anywhere
Forge generates native dbt models for BigQuery, Snowflake, Redshift, and Databricks simultaneously from one JSON source.
Full dbt Infrastructure
Get production-ready dbt models executed automatically—no separate dbt Cloud subscription needed (saves $300-500/month).
Get Started with Forge
💰 Transform JSON into AI-governed, query-ready tables for BigQuery, Snowflake, Databricks, or Redshift. Most customers see 3-5x ROI in the first month through compute savings alone.
Start Your Free Trial
30-Day Free Trial
Full access to test Forge
AI Features Included
Excalibur + Pridwen in trial
No Credit Card
Start immediately
Pricing Options
Monthly Starter
$299/month
Up to 100M rows, 5 job profiles, all warehouses + AI.
Monthly Professional
$999/month
Up to 1B rows, unlimited profiles, priority support.