Google BigQuery Live

Note: Google BigQuery is currently in Beta.

This topic describes how you can add live connections to your Google BigQuery databases in Sisense. For information about live connections, see Sisense Live Connect.

Sisense enables easy and quick access to tables contained within Google BigQuery. To connect to your Google BigQuery database, you need to provide a Project ID. The Project ID is a unique identifier for your BigQuery project. You receive the Project ID when you create a project in Google BigQuery.

If you have already created a project and can’t find the Project ID, click here for help.

After you provide the Project ID, you can sign into your BigQuery account with your Google credentials. Once Google has authenticated your account, you can select what tables are to be imported into Sisense.

Note: If you are connecting to a Google service remotely, and the address of Sisense is something other than localhost, Google requires that you connect using the OAuth 2.0 protocol. See Google Authentication for more information.

To add Google BigQuery live connection:

  1. In the Data page, open a live model or click to create a new live model.
  2. In the Model Editor, click . The Add Data dialog box is displayed.
  3. In the Add Data dialog box, select Google BigQuery.
  4. In Project ID, enter your BigQuery Project ID.
  5. Click Sign in with Google and enter your email, and then select Next to enter your password. If you have multiple accounts, select the account that has the Google BigQuery data you want to access and enter the password, if you're not already signed in. You must be signed out of all other Google accounts.
  6. Click Accept to allow your Sisense Server to access your Google BigQuery data.
  7. Close the browser window when notified to do so.
  8. Click Next. All tables and views associated with Google BigQuery are displayed.
  9. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it.
  10. After you have selected all the relevant tables, click Done. The tables are added to your schema.

Limitations

The following functions are not supported for Google BigQuery: