Skip to main content

BigQuery

Squid can connect to a BigQuery database to serve as the data source for your Squid application.​

BigQuery is a fully managed, AI-ready data analytics platform that helps you maximize value from your data and is designed to be multi-engine, multi-format, and multi-cloud.

To integrate your BigQuery database with Squid, complete the following steps:

  1. Open the Squid Console and select your application to use with BigQuery.
  2. Click the Integrations tab, and then click Available integrations to view all integrations.
  3. Select the BigQuery integration.
  4. Provide the following configuration information:
  • Integration ID - Choose an ID that is brief and helps identify the integration.
  • Project ID - The Google Cloud project ID.
  • Service account email - The email of the Service Account used to authenticate with BigQuery. For more information on Google Cloud Service Accounts, view the Google Cloud documentation.
  • Dataset ID - Your BigQuery dataset ID. For more information, view the Google Cloud documentation on datasets.
  • Private key - Your Service Account credentials. For more information on Google Cloud Service Accounts, view the Google Cloud documentation. Your credentials are securely stored using Squid Secrets.

Once you've entered the connection information, click Test connection to confirm that the connection is configured properly, and then click Add integration.

BigQuery integration

Securing your database​

By default, security rules are required, and in a production environment, it's essential to never allow access to the integration without them. Learn more about securing your database data in the security rules documentation.

To learn how to work with BigQuery data in Squid, view the Client SDK documentation.