BigQuery schema

In this folder you will find the schema for the tables and views of the Cardano on BigQuery project.

Tables

In the tables folder you will find the schema of the BigQuery tables in json format. You can use the BigQuery command line tool bq to create the tables. For example the command:

bq mk --schema ./tables/schema_version.json <bq_project>:cardano_mainnet.schema_version

would create the schema_version table.

Views

The views folder contains the SQL code for all the views used by the update and compare scripts in the db-sync Postgres database. All the views reside in the analytics database schema.