This is a Data Model for the information_schema.jobs in BigQuery. It queries the BigQuery Information Schema to give you information about how your internal users are using BigQuery. What queries are they running, how much compute are they using, and which tables are the most frequently queried?
- Open up Google Cloud Code
- Install the Malloy VS Code extension in your Cloud Code IDE
- Clone this Git repository in your Cloud Code IDE
- Modify config.malloy to point to your data
- Open up the dashboard.malloynb file and run all the queries in the notebook.
You can use your Malloy model to build governed views in your database, by embedding Malloy queries into CREATE VIEW AS ... SQL statements. The following files show how:
- Create Views - this script persists a set of views in the database
- SQL Examples - this script is an example of querying the views created above