Menu
In BigQuery Web UI, there is a “Saved Queries” Section.
Is there way to access (read/write) those programmatically?
Any API?
240
View saved queries Saved query functionality is available only in the Google Cloud console. To view a saved query, open the BigQuery Google Cloud console, expand your project node in the Explorer panel, and then expand the Saved queries ( N ) node, where N indicates the number of saved queries in your project.
A saved query is a component that you create to run SQL statements against a database. You can use a saved query as the source object in a. synchronization. task or as the query in an SQL transformation.
All customers get 10 GB storage and up to 1 TB queries free per month, not charged against their credits. BigQuery is at the core of Google's unified data cloud. Watch the demo to see how it works.
Nope. It's a UI-only feature with a private interface. But we'll consider this a feature request!
Update 2021: We recommend using scripts to save and share queries.
https://cloud.google.com/blog/products/data-analytics/command-and-control-now-easier-in-bigquery-with-scripting-and-stored-procedures
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
