Overview
Go Fig centralizes all your data into one hub for your organization. Connect to databases and warehouses, sync data from your SaaS applications, upload spreadsheets- Databases & Warehouses: Connect to data directly from its source (e.g. Snowflake, BigQuery, Azure SQL, PostgreSQL and more)
- Sync Connectors: Automated syncs extract data from external apps (e.g. HubSpot, Stripe, QuickBooks, Google Ads and more)
- Uploads & Spreadsheets: Upload local files (CSV, JSON, Parquet) or connect your online spreadsheets (e.g. Google Sheets and Excel Live Sheets)
Before connecting databases or warehouses, ensure that you whitelist GoFig.ai’s IP address in your firewall or security group settings:
104.196.71.57Specific connector Connection Guides
For detailed setup instructions for each connector type: Databases & Warehouses:- Snowflake - Enterprise data warehouse
- BigQuery - Google Cloud data warehouse
- Azure SQL - Microsoft Azure database
- PostgreSQL - Open-source relational database
- Sync Connectors - HubSpot, Stripe, QuickBooks, Google Ads, etc
- Google Sheets - Live spreadsheet connections
- File Uploads - CSV, JSON, and Parquet files
Best Practices
Organize data via collections: Organize related data sources in the same Collection for easier management and team collaboration.
Security: Use service accounts with minimum required permissions for database connections. Never use personal admin accounts.
How Data Connections Work
When you connect a data source to Go Fig:- Secure Authentication: OAuth or encrypted credentials stored in Google Secret Manager
- Schema Discovery: Go Fig automatically detects tables, columns, and data types
- Data Access: Query directly from source (warehouses) or sync to Go Fig (apps/sheets)
- Always Fresh: Data stays in sync with automatic or manual refresh options

