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).