Skip to main content

BigQuery

BigQuery is Google's fully managed, serverless data warehouse that enables super-fast SQL queries using the processing power of Google's infrastructure. It's designed for analyzing large datasets efficiently and cost-effectively.

Timbr + BigQuery Logo

Integrating BigQuery with Timbr combines the strengths of both platforms. It allows you to use Timbr's semantic graph capabilities alongside BigQuery's powerful data processing features. This integration enhances your ability to perform semantic querying, data virtualization, and integrated data management across large-scale datasets, leading to deeper analytics and more efficient data operations.

Getting Started with BigQuery​

If you haven't yet connected to a BigQuery project, follow these steps to set up and establish a connection:

To connect Timbr to your BigQuery datasource, you need to use the BigQuery JDBC driver. For information on the BigQuery JDBC driver and how to set it up, refer to the BigQuery JDBC Driver documentation.

Connecting Timbr to BigQuery in the Timbr Platform​

Once you've connected to a BigQuery database and have the JDBC driver ready, it's time to connect Timbr to BigQuery. Follow the steps below for a detailed tutorial on connecting Timbr to BigQuery:

  1. Navigate to Manage Datasources: From the Timbr interface, click on the Manage tab and select Datasources.

  2. Add New Datasource: On the top right, click the Add New Datasource button. Alternatively, you can click the big add button beneath the knowledge graphs and datasources tabs.

Add new datasource

  1. Fill in Connection Details: A pop-up window will appear where you need to provide the relevant connection details to connect BigQuery to Timbr.

There are two options in Timbr to enter the connection information: Simple or JDBC Url.

On the top right of the pop-up window , the toggle can be switched from Simple to JDBC Url in order to connect the datasource using the relevant JDBC URL.

tabs

Simple Tab Connection Configuration​

  1. Select Simple Tab: Ensure the Simple tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select Google BigQuery.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • Hostname / IP: Enter the hostname or IP address of the BigQuery database.
    • Port: Default is 443.
    • ProjectId: Enter the Project ID for your BigQuery account.
    • OAuth account email: Enter the OAuth account email.
    • Private Key: Either enter the private key path or choose a file by clicking the "Choose File" button.
    • Additional Parameters: Add any additional connection parameters using ;

JDBC URL Tab Configuration​

  1. Select JDBC URL Tab: Ensure the JDBC URL tab is selected.

  2. Fill in the Following Details:

    • Database Type: Select Google BigQuery.
    • Datasource Name: Enter a name for your datasource.
    • Description: Provide a description of the datasource (Optional).
    • JDBC URL: Enter the JDBC connection URL (e.g., jdbc:bigquery://https://www.googleapis.com/bigquery/v2:port;OAuthType=0).

jdbc tab

Save and Test Connection​

  1. After entering the details, click the Save button to save the information, connecting the BigQuery datasource to the Timbr environment.
  2. Once saved, on the top right, click the Test connection button to verify the datasource’s connectivity, ensuring it is active and responsive.

For a comprehensive guide on connecting Timbr to various datasources, refer to the detailed documentation: