Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Any similar experience or alternative approaches used?
Going twice...