Big Query is a fully managed cloud-based data warehouse offered by Google Cloud Platform that provides high-speed querying and interactive analysis of large datasets using SQL-like queries.
- Get Big Query database connection parameters from the database owner.
- Refer to IP allowlist to add IP addresses of Openblocks to your allowlist (if needed).
Follow the steps below:
-
Create a new data source in two ways. Note that this permission is restricted to workspace admins and developers.
-
Navigate to the Data Sources tab on Openblocks Homepage and click New data source.
-
When creating a new query in the app editor, click + New > + New data source.
-
-
Select Database > Big Query as the data source type.
-
Set its name and service account.
-
(Optional) Click Test connection to check whether the new data source is successfully connected.
-
Click Save, and it will be saved to your data source library.
