how to pass a custom query from google data studio to BigQuery using BigQuery connector?

Question

I have read the document of BigQuery connector(https://support.google.com/360suite/datastudio/answer/6370296?hl=en).

I want to pass a custom query from data studio to Bigquery.

But I don't know where I should wirte the SQL code on the UI interface.

Is there any ideas? Thank you!

Answer 1

Start New Report >> CREATE NEW DATA SOURCE >> Choose BigQuery in Connectors List >> Choose Project >> Enter Custom Query