Create a connection to BigQuery

  1. Open the Visualization page in the console.

  2. Select your workbook or click Create workbook to make a new one.

  3. Click CreateConnection in the upper-right corner of your workbook page.

  4. Select BigQuery. You'll see the following page:

    bigquery-connection-interface

  5. Specify your Google Cloud Project ID .

  6. Upload a file with your Service account authorized key for authentication.

  7. Configure the Raw SQL level. It enables you to use an ad-hoc SQL query to create a dataset on the fly:

    • Forbid is the default setting. It handles all SQL queries automatically.

    • Allow subselects in datasets gives access to manual operations with SQL queries and subqueries. Use with caution and only if necessary.

  8. Under Cache TTL in seconds, specify how long to store cache.

    You can keep the Default value or select Customized to set this value manually.

    Tip

    We recommend using 300 seconds (5 minutes) for this setting.

  9. Click Check connection:

    • If your connection is operational, you'll see a green icon.

    • If there is a problem, a red icon will appear. You'll also see a popup message with a Details button to check service information about the error.

  10. Click Create connection.

  11. Name your connection and click Create.

See also