Connecting to Google BigQuery

Note: Google BigQuery is currently in Beta.

Sisense enables easy and quick access to databases, tables and views contained within Google BigQuery.

Note: If you want to export large volumes of data from Google BigQuery, Sisense recommends you use a live connection.

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 import Google BigQuery data:

  1. In the Data page, open an ElastiCube or click to create a new ElastiCube.
  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. When you select the table or view, a new option is displayed at the bottom of the list, Add Import Query.
  10. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
  11. 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: