Export selected dashboard data to BigQuery

[Arthur_Renault]

Hi there,

We want to enable our users to write the selected data of a dashboard to a BigQuery table. The rationale is simple:

1. The users select the scope of their analyses by filtering the data (see illustrative screenshot).
2. They push the selected data to BigQuery.
3. Our data science team runs ML models based on the selected inputs.

I found 2 topics discussing data export to BigQuery but I did not manage to adapt the code to our use case.

• https://community.looker.com/sql-10/update-write-back-data-on-bigquery-from-looks-9408

  Updates a BigQuery table from a Look but based on a single field value.

• https://community.looker.com/open-source-projects-78/export-the-results-of-a-looker-query-to-bigquer...

  Updates a BigQuery table based on all selected values but from an Explore.

In our scenario we want our users to push to BigQuery all the selected data, directly from the dashboard.

How can we enable it?

Best,

Arthur