What's Included In The Integration?

BigQuery data objects:

• Tables
• Views
• Materialized Views
• User-Defined Functions
• Stored Procedures

BigQuery capabilities:

• SQL query execution
• Data import/export
• Streaming inserts
• Geospatial analysis
• Machine learning model integration (BigQuery ML)

Airfold actions:

• Execute SQL queries on BigQuery data
• Import BigQuery data into Airfold
• Create custom metrics and KPIs using BigQuery data
• Generate AI-powered insights from BigQuery datasets
• Write back aggregated data or insights to BigQuery
• Schedule and automate data syncs and report generation

How to Set It Up

1. Log in to your Airfold account and navigate to the Integrations page.
2. Find and select the BigQuery integration.
3. Click "Connect" and you'll be prompted to authenticate with your Google Cloud account:
   • You may need to log in to your Google account if not already authenticated
   • Select the Google Cloud project that contains your BigQuery datasets
   • Grant the necessary permissions for Airfold to access your BigQuery data
4. Once authenticated, choose which BigQuery datasets and tables you want to sync with Airfold.
5. Set up the sync frequency (real-time, hourly, daily, etc.).
6. Configure any custom SQL queries or data transformations you want to perform during the sync process.
7. Set up any specific automations or workflows you want to create between BigQuery and Airfold.
8. Optionally, configure advanced settings such as data partitioning, clustering, or query optimization.
9. Save your settings and start using BigQuery data in your Airfold dashboards and reports.