Google BigQuery is a cloud database like system that is used mostly for querying data powered by Google Cloud Platform (GCP).
Stambia Data Integration allows to work with Google BigQuery databases to produce fully customized Integration Processes.
The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
This component may require a dedicated license.
Please contact the Stambia support team if you have any doubt and if you need to use it in a production environment.
You must install Google Cloud Platform connector to be able to work with Google BigQuery.
Please refer to the following article that will guide you to accomplish this.
When the installation is completed, you can lead to this getting started article which explains how to work with Google BigQuery in Stambia.
You can find below an overview of what Stambia DI can do with Google BigQuery databases
The database structure can be reversed in a dedicated Metadata
|Google BigQuery as Target||
Data can be loaded into Google BigQuery from any database, flat file, or directly from GCS.
|Google BigQuery as Source||The connector supports reading data from Google BigQuery to load it into another database, file, ...|
Data can be sent to Google BigQuery with the following methods:
When integrating data into Google BigQuery using the storage method, you have the choice of how it should be done:
Depending on the amount of data sent and network quality, for instance, one method or the other can have better performances
Stambia's Google BigQuery connector is using Standard SQL as default query mode.
All statements supported by Google BigQuery's Standard SQL can therefore be used seamlessly without any particular configuration.
|Data consultation||The connector supports consulting Google BigQuery data directly from the Designer.|