Google BigQuery

Qlik Google BigQuery Connector allows you to make synchronous queries to Google BigQuery from QlikView and Qlik Sense as well as list your projects, datasets and tables. To use the data in BigQuery, it first must be uploaded to Google Storage and then imported using the BigQuery HTTP API.

Tip:

The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.

Connecting to data sources

Ways to access your data

To use the QlikGoogle BigQuery Connector you must have a Google account, with which to authenticate the connector.

After authenticating the connector a number of tables are available:

  • Projects - Lists the projects to which you have, as a minimum, read access.
  • DataSets - Lists all the datasets in the specified project to which the caller has read access. However, a project owner can list all datasets in their project.
  • Tables - Lists all tables in the specified dataset. To call this method, you must have one of the following rights: Dataset READ, Dataset WRITE, or Dataset OWNER.
  • TableSchema - Returns schema information for the specified table.
  • TableSchemaAsXML - Returns schema information for the specified table as XML.
  • SynchronousQuery - Runs a BigQuery SQL query synchronously and returns query results provided the query completes within a specified timeout (default 30 mins).
  • SynchronousQueryAsXML - Runs a BigQuery SQL query synchronously and returns query results as XML provided the query completes within a specified timeout (default 30 mins).

You can find additional information and examples about running queries in the Google BigQuery developer documentation.

Quotas and Limits

There are some limits to the size of the queries which can be performed and the number of results which can be returned:

  • Maximum query length: 256 KB
  • Maximum response size: 128 MB compressed
Note:

Large result sets are not currently supported.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?