Tableau – Google BigQuery configuration

Prerequisites

  • Access to a Google Cloud Platform account.
  • The Reporting Data Layer stored in a Google Cloud Bucket.
  • You have created the required tables and views in BigQuery.

Tableau configuration

Connect to Google BigQuery

  1. In Tableau Desktop, select ConnectTo a ServerGoogle BigQuery.

    A browser window appears.

  2. In the browser, sign in with your Google account.
  3. Allow Tableau to access your Google account.

  4. In Tableau Desktop, select your Google BigQuery dataset details:
    • Billing Project: for example, Collibra Insights.
    • Project: for example, Collibra Insights.
    • Dataset: for example, insights.

    The tables of the dataset become available.

Test the connection

  1. In Tableau, select New Custom SQL.
  2. Enter the following query:
    select
        c.community_name,
        d.domain_name,
        a.*
    from insights.asset a
    join insights.domain d
    on a.domain_id = d.domain_id
    join insights.community c
    on c.community_id = d.community_id
  3. Click OK to run the query.
  4. Select Update Now to view the data.

Create the report

  1. Create a new Tableau sheet and perform the following actions:
    1. From the Dimensions section, drag community_name to the Rows section.
    2. From the Measures section, drag Number of Records to the Columns section.
    3. From the Measures section, drag Number of Records to the Marks section, on top of the Label icon.
    4. In the Marks section, choose Bar.
    5. Sort the chart in descending order by Sum of Records.

  2. Provide a meaningful name for the sheet, for example, Number of assets per community.
  3. Create a new dashboard, for example, Assets per community.
  4. Drag the sheet to the dashboard.
  5. Save the workbook.

Publish the data

  1. Sign in to Tableau Server: ServerSign In….
  2. Choose a site.
  3. Select ServerPublish Workbook….

    A browser window appears.

  4. In the browser, sign in with your Google account.
  5. Allow Tableau Server to access your Google account.

    Tableau Desktop displays the published workbook.