​

Install

Run the following command to install the connector from the root of your project:

npm install --save @latitude-data/bigquery-connector

​

How to configure sources

The sources files must be inside the queries/ folder.

​

Configuration

To configure the connection with your Bigquery database follow these steps:

type: bigquery
details:
  projectId: string
  token: string
  credentials: 
    client_email: string
    private_key: string

​

Attributes

• project_id → The unique identifier for your Google Cloud project. It’s like the address for where all your BigQuery activities live, helping Google know which project your data and queries belong to.
• credentials → (Optional) To connect via service account authentication
  • clientEmail -> Your service account email
  • privateKey -> Your service account private key
• token → (Optional) To connect with Oauth client ID authentication. This is Oauth’s access token, which can be generated with gcloud’s cli: gcloud auth print-access-token

For authentication, you’ll either have to choose the Credentials or Token approach. In case both are defined, Credentials approach takes preference.

​

Test connection

To test the connection you can:

1. Create a query .sql in the queries directory that points to a table of your new connection in the FROM clause. See the section SQL Syntax Basics to learn more.
2. Use the command line to run latitude run query_file_name where query_file_name is the name of your .sql file. This will display the results in your terminal. See the section Running queries to learn more about how to query your data.