Solved: direct query from lookml to big query

otaku

Hello,

My requirement is to utilize Looker Studio by connecting to LookML. I need the connection from LookML to BigQuery to be a direct query. This means, for instance, that every time a user attempts to apply a filter in the report, a new query is sent to BigQuery. Is this achievable with Looker?

Thank you.

Emma_Docs

Hey there! If you're using the Looker <> Looker Studio connector then queries coming from Looker will be running directly against the database in realtime (assuming no caching is set up on the Looker side).

So yes, if a user applies a filter in Looker Studio, that filter will be applied to the Looker query which will run on your database (like BigQuery).

View solution in original post

Emma_Docs

Hey there! If you're using the Looker <> Looker Studio connector then queries coming from Looker will be running directly against the database in realtime (assuming no caching is set up on the Looker side).

So yes, if a user applies a filter in Looker Studio, that filter will be applied to the Looker query which will run on your database (like BigQuery).