Creating a dataset using Google BigQuery
Note
When QuickSight uses and transfers information that is received from Google
APIs,
it adheres to the Google
API Services User Data Policy
Google BigQuery is a fully managed serverless data warehouse that customers use to manage and analyze their data. Google BigQuery customers use SQL to query their data without any infrastructure management.
Creating a data source connection with Google BigQuery
Prerequisites
Before you start, make sure that you have the following. These are all required to create a data source connection with Google BigQuery:
-
Project ID – The project ID that is associated with your Google account. To find this, navigate to the Google Cloud console and choose the name of the project that you want to connect to QuickSight. Copy the project ID that appears in the new window and record it for later use.
-
Dataset Region – The Google region that the Google BigQuery project exists in. To find the dataset region, navigate to the Google BigQuery console and choose Explorer. Locate and expand the project that you want to connect to, then choose the dataset that you want to use. The dataset region appears in the pop-up that opens.
-
Google account login credentials – The login credentials for your Google account. If you don't have this information, contact your Google account administrator.
-
Google BigQuery Permissions – To connect your Google account with QuickSight, make sure that your Google account has the following permissions:
-
BigQuery Job User
at theProject
level. -
BigQuery Data Viewer
at theDataset
orTable
level. -
BigQuery Metadata Viewer
at theProject
level.
-
For information about how to retrieve
the previous prerequisite information, see Unlock the power of unified business intelligence with Google Cloud BigQuery
and Amazon QuickSight
Use the following procedure to connect your QuickSight account with your Google BigQuery data source.
To create a new connection to a Google BigQuery data source from Amazon QuickSight
-
Open the QuickSight console
. -
From the left navigation pane, choose Datasets, and then choose New Dataset.
-
Choose the Google BigQuery tile.
-
Add the data source details that you recorded in the prerequisites section earlier:
-
Data source name – A name for the data source.
-
Project ID – A Google Platform project ID. This field is case sensitive.
-
Dataset Region – The Google cloud platform dataset region of the project that you want to connect to.
-
-
Choose Sign in.
-
In the new window that opens, enter the login credentials for the Google account that you want to connect to.
-
Choose Continue to grant QuickSight access to Google BigQuery.
-
After you create the new data source connection, continue to Step 4 in the following procedure.
Adding a new QuickSight dataset for Google BigQuery
After you create a data source connection with Google BigQuery, you can create Google BigQuery datasets for analysis. Datasets that use Google BigQuery can only be stored in SPICE.
To create a dataset using Google BigQuery
-
Open the QuickSight console
. -
From the start page, choose Datasets, and then choose New Dataset.
-
On the Create a dataset page that opens, choose the Google BigQuery tile, and then choose Create dataset.
-
For Tables, do one of the following:
-
Choose the table that you want to use.
-
Choose Use custom SQL to use your own personal SQL statement. For more information about using custom SQL in QuickSight, see Using SQL to customize data.
-
-
Choose Edit/Preview.
-
(Optional) In the Data prep page that opens, you can add customizations to your data with calculated fields, filters, and joins.
-
When you are finished making changes, choose Save to save and close the dataset.