Qlik Community

Ask a Question

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Amberj_29
Contributor III
Contributor III

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

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"

 

Labels (5)
0 Replies