Forge — Transform Nested JSON into Analytics-Ready Tables
Your app uses NoSQL. Your analysts need SQL. Forge transforms nested JSON into query-ready tables — with
automatic documentation and PII detection built in.
What Forge Does
- 10 Minutes to Production — Point Forge at your raw JSON table (MongoDB exports, Firestore,
API event streams) and get fully parsed, normalized SQL tables.
- Dual Output — Both normalized tables (for complex JOINs) and a rollup table (for simple
exploration) from one parse.
- Automatic Documentation — Every field gets a description, data type, and test coverage.
Generated from real API specs, not guesses.
- PII Detection — Automatically identifies emails, phone numbers, SSNs, addresses, and 20+
PII types. Flags them for compliance.
- Multi-Warehouse — One parse generates native models for BigQuery, Snowflake, Databricks,
and Redshift.
The Problem Forge Solves
Manually unnesting nested JSON into SQL tables takes data engineers 2-4 weeks per API. Forge does it in 10
minutes — and handles schema changes automatically.
Cost Savings
60-90% query cost reduction vs. raw JSON querying. $47,000-$470,000 estimated annual savings for teams with 100
analysts.
Supported Sources
MongoDB, Firestore, Stripe API, Slack Events, HubSpot, Shopify, and any nested JSON data in BigQuery,
Snowflake, Databricks, or Redshift.
Pricing
- Sandbox — Free, 1 source table
- Starter — $99/month, 3 source tables
- Professional — $499/month, 10 source tables
- Enterprise — Custom pricing, unlimited tables, in-VPC deployment
Start Free Trial | Try the Sandbox | Contact Sales
© Foxtrot Communications. Google Cloud Partner. Support