Time Taken to read a Table in Google BigQuery through Simba ODBC from QlikView
Hi Team,
We are starting to use QlikView (April 2020, SR3 12.50) to connect to Google BigQuery through Simba ODBC in lower environment. The ODBC is getting connected in some seconds (no issues), but while reading the Columns and data it is taking comparatively high time.
Even when the table has no data for a particular condition (0 Lines Fetched), the reading/extraction takes 15 Minutes average.
Simba Drivers are configured using Google SA Account and JSON File.
Any expert suggestions here - how to reduce the duration here? Should we try using ODBC Connector package ?