I successfully loaded Qlik data to Google Cloud Storage using store command. Now, I'm trying to load data from Qlik Sense to Google BigQuery. I'm able to load data from BigQuery to Qlik Sense but can't able to load data from Qlik to Google BigQuery. Can you please let me know how to do it because store command is not working here. Thanks in advance.
except calling where I specified as call qlik.writeback('$(vAlert)','$(vDesk)'); !EXECUTE_NON_SELECT_QUERY;
In editor, everything is good but !EXECUTE_NON_SELECT_QUERY; is in red color(error).
While executing, I'm getting error at call qlik.writeback('alert1','desk1')
a) Function in BigQuery is not supporting "begin and end" so I used procedure over function
b) I read that this QvOdbcConnectorPackage.exe.config file should be configured from false to true to allow non_select_query but I can't able to as I don't have installed the application rather accessing QlikSense Cloud directly in the browser.
Hey, It's working! I put SQL before the calling and it worked with no errors. Thank you so much.
I have a query on this. My goal is to move data from QlikSense to BigQuery and I'm left with two options either direct migration from QlikSense to BigQuery or take help of Google Cloud Storage(QlikSense -> Google Cloud Storage -> BigQuery).
Which option is more preferable?
My understanding is to take help of Google Cloud Storage because 'inserts' (insert data from qlikSense to BigQuery one by one) degrade the performance of BigQuery as BigQuery is Column oriented(analytics) rather row oriented database(transactions/operations).
Hmm, that's a good question. I don't know if I can speak to that with much experience with it. Our org. doesn't have the Google Cloud Connector set up. I'm not sure if you would this method above to send the data through the Cloud connector. Might be worth starting another thread weighing the two options, or maybe inquiring on the Qlik Branch Slack channel.