2

I created a saved query in Bigquery and I would like to pull that saved query into metabase. Does anyone know if this is possible? I am not able to export it to a JSON file.

Saved Query in my database

These are my only options: Export Options

David Guckian
  • 21
  • 1

1 Answers1

0

According to the screenshots provided, that isn't a "Saved query". What you are talking about is a VIEW. Unfortunately, you can't export views. This is documented here.

You cannot run a BigQuery job that exports data from a view.

This is documentation for "Saved queries" which is different than views.

This page describes how to save and share queries. Queries that are saved or shared contain only the query itself, which means that:

  • A shared query provides the query text only. You still need to have appropriate access to query the data. One advantage of saving only the query text is that you can share a query that is incomplete, even if it isn't a valid query, and use it as a template that other users can complete or customize.
  • The only query option retained by a saved query is the "SQL Version", which governs whether the query uses legacy SQL or standard SQL.
Alvaro
  • 813
  • 8
  • 16