Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

Google BigQuery Connector For QlikView & Qlik Sense

RSS
Modified on 2016/05/03 10:19 by chrisb Categorized as connector

Usage

This Connector allows you to make Synchronous queries to Google BigQuery from QlikView and Qlik Sense as well as list your projects, datasets and tables.

For example, we can use the BigQuery Browser Tool (Quickstart here) to try out one of the sample queries:

A few simple SELECT queries
Heaviest 10 children
SELECT weight_pounds, state, year, gestation_weeks FROM publicdata:samples.natality
ORDER BY weight_pounds DESC LIMIT 10;

A popular myth debunked!
SELECT word FROM publicdata:samples.shakespeare WHERE word="huzzah";

A few count queries
How many works of Shakespeare are there?
SELECT corpus FROM publicdata:samples.shakespeare GROUP BY corpus;

Which are the longest works?
SELECT corpus, sum(word_count) AS wordcount FROM publicdata:samples.shakespeare GROUP BY corpus ORDER BY wordcount DESC;

There are also some other sample tables listed here.

Let's take the first example. Note that as well as entering the query we also need to enter the ID of a project we have set up which would be used for billing (if applicable):

Image

You can find the full Query reference here.

If you would like to see us add other features and functionality into this connector please contact us.

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 - you can read more about these here.

At time of writing the following query quotas are in place:

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

Read the full details here.

Please note, large result sets are not currently supported.

Change Log

1.0.2 - 22/02/16
  • Default timeout increased to 30 minutes.

1.0.1 - 09/11/15
  • Query (for SynchronousQuery and SynchronousQueryAsXML tables) can now contain line breaks.
  • Added paging to Projects, DataSets, Tables and TableSchema tables (as well as progress feedback and ability to cancel running table).

1.0.0 - 12/06/15
  • Taken out of beta.

0.8.4 - 12/06/15
  • Query label now contains note to avoid using new lines in query and this is also checked now before Query tables run.

0.8.3 - 01/04/15
  • Added a new TableSchema table.

0.8.2 - 25/11/14
  • Fixed incorrect timeout in descriptions of query tables.
  • Fixed bug with possible insufficient timeout set.
  • Fixed bug where SynchronousQuery table would only return a maximum of 100,000 rows. The table now extracts data in batches of 25,000 rows and has a progress bar and cancellation available.
  • Added table note that SynchronousQueryAsXML will only return a maximum of 100,000 rows.

0.8.1 - 16/06/14
  • Increased timeoutMs of SynchronousQuery from 1 minute to 10 minutes.

0.8.0 - 28/04/14
  • Initial version.
  Name Size
- BigQuery Example.png 48.59 KB


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd