This article will help you learn about how Daasity replicates data from a BigQuery database, limitations to the data we can extract and where the data is stored.
Key Topics
Click on the links below to take you to the section where you can learn more about this Integration
Integration Overview
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service that supports querying using ANSI SQL.
Integration Availability
This integration is available for:
- Pro V2
NOTE: You are considered V2 if...
- Your account says Pro V2 in the Daasity App
Not sure? Reach out to Support@Daasity.com
Integration Details
Daasity connects to BigQuery databases via an ODBC connector. Some key notes on the Daasity method for data replication:
- A user will be needed that has read permissions in the BigQuery database. This user will access via ODBC and execute the data replication
- Data replication is performed by running SQL queries against the BigQuery database and thus will incur costs on your BigQuery instance
- The DDL is read at time of initial setup and sets the definitions for all the tables. If tables are added, deleted or modified please contact Daasity Support