Before you configure this connector, you have to whitelist the Less IP address. This enables Less to connect to your database and extract data from the database.

Read more here and feel free to contact us if you need assistance whitelisting.

Query-based database connection can be helpful if you have large datasets that you want to extract to Less. You can reduce the dataset size (rows and/or columns) with the SQL query. That will make the dataset more lightweight and ultimately ensure that the connector updates faster.

Query-based database connection - such as this one - only extract a single table per connection

1

Authenticate with OAuth

Click “Connect to ” and you will be redirected to authenticate with your account.

2

Project ID

Input the Project ID of your BigQuery environment. You can find the from the Console home tab.

3

Input SQL Query

Enter the SELECT query that will extract the data you need. The query should return data from a single table. Include any needed WHERE clauses, JOINs, or other SQL operations to filter and shape the data appropriately.

Remember to use the full dataset - like some-project.some-schema. below.

    SELECT  FROM `some-project.some-schema.budget_table` LIMIT 1000

You cannot extract data from External Tables - such as reference to a Google Sheet. This connector only works with Standard BigQuery Tables.