Google Bigquery (Big query) - Connecting to a saved query

Amberj_29 — Sat, 16 Nov 2024 03:33:11 GMT

Hello All,

I am wondering how to connect to a saved/ scheduled query in Google BigQuery (if possible)? I have set up the bigquery connection all fine with Qlik Sense online.

If it is not, How would I run the SQL query in the load script? for some reason I am having an issue with the UNNEST function in it. It is also important that I am able to load data from all tables (dates) - as I can do this in bigquery, so can this be done in Qlik, or do I have to load each table separately? I am using standard SQL:

SELECT event_date, event_timestamp, user_pseudo_id, geo.country, geo.region,
(select value.string_value from unnest (event_params) where key = "item_category") as question,
(select value.string_value from unnest (event_params) where key = "correct") as score,
(select value.string_value from unnest (event_params) where key = "item_context") as Question_Bank
FROM `test_database_*`
where event_name = "item_answered"

Re: Google Bigquery (Big query) - Connecting to a saved query

dyy — Tue, 19 Oct 2021 13:02:18 GMT

Did you ever resolve this?

topic Google Bigquery (Big query) - Connecting to a saved query in Integration, Extension & APIs

Google Bigquery (Big query) - Connecting to a saved query

Re: Google Bigquery (Big query) - Connecting to a saved query