Skip to content

mozilla/bigquery-etl

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 

Repository files navigation

Generated SQL

This generated-sql branch is based on the sql directory of the default branch, but includes additional programmatically generated content, including:

  • Views on top of stable ping tables
  • Derived tables giving daily aggregations on top of Glean baseline pings
  • metadata.yaml file that includes more information about the views, including referenced tables

Currently, this branch is used as the basis for generating documentation on user-facing views, and for retrieving table references during LookML generation. It may evolve into an artifact used for deployment and management of derived tables in BigQuery.

See the generate-sql task in the repository's .circleci/config.yml for the specifics of what gets generated.