Data Warehouse Integrations
Connect BigQuery, Redshift, Snowflake, Databricks, and SAP HANA to Edilitics. All five support source and destination, DQ profiling, AI column insights, and AskEdi sessions.
Edilitics supports five cloud data warehouses as both sources and destinations.
| Integration | Source | Destination | DQ Profiling | AI Insights | AskEdi | IP Whitelisting |
|---|---|---|---|---|---|---|
| Google BigQuery | Yes | Yes | Yes | Yes | Yes | No |
| Amazon Redshift | Yes | Yes | Yes | Yes | Yes | No |
| Snowflake | Yes | Yes | Yes | Yes | Yes | No |
| Databricks | Yes | Yes | Yes | Yes | Yes | Yes |
| SAP HANA | Yes | Yes | Yes | Yes | Yes | Yes |
All five support full load, incremental, and CDC as destinations in Replicate pipelines. CDC as a source is not supported for any data warehouse integration.
BigQuery, Redshift, and Snowflake connect over HTTPS and need no IP whitelisting: authentication is credentials supplied directly in the connection form. SAP HANA requires the Edilitics IP address whitelisted in your network before the connection will succeed. Databricks connects the same way, directly to your workspace, so if your workspace enforces an IP access list, add the Edilitics IP address to it before connecting.
Select an integration above for connection setup instructions.
Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.
SQL Server on GCP
Learn how to integrate Google Cloud SQL Server with Edilitics. Step-by-step guide for setting up, configuring, and connecting your database.
BigQuery
Connect Google BigQuery to Edilitics as a source or destination. Step-by-step setup for Service Account and User Account authentication.