Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
stevejoyce
Specialist II
Specialist II

QlikSense Extract from Google BigQuery

QlikSense extract from Google BigQuery is very slow...  select 1 column, 15 million rows = takes 2 minutes (On-prem windows qse - version Feb 2019 sr1).

Bottle-neck is not on engine resources.  I haven't ruled out network bandwidth being an issue.

I am using the Qlik Google BigQuery connector.

 

I've seen articles around alternative 3rd party connector/odbc drivers.

 

Is 2 minutes to load 1 column x 15mm rows normal pereformance with the Big Query connector?

Has Qlik made improvements on the connector since version Feb 2019?

Advice on troubleshooting if it were a network latency issue?

Any experience on how to speed this up? 

 

Thanks for input!

Labels (2)
2 Replies
stevejoyce
Specialist II
Specialist II
Author

Any similar experience or alternative approaches used?

stevejoyce
Specialist II
Specialist II
Author

Going twice...