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. It 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 Connectors tab, and then click Available connectors.
  3. Select the BigQuery connector.
  4. Provide the following configuration information:
  • Connector ID - Choose an ID that is brief and helps identify the connector.
  • 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. Then click Add connector.

BigQuery connector

Securing your database​

By default, security rules are required. In a production environment, it's essential to never allow access to the connector 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.