example table schema

example_table_schema.json

{
  "$schema": "../../json_schemas/table_definition.schema.json",
  "tableName": "billedusage",
  "tableType": "transactional fact",
  "dataset": "sid_common",
  "description": "Total bill for per customer per month",
  "labels": {},
  "clusteringColumns": [],
  "columns": [
    {
      "name": "subscription_id",
      "type": "STRING",
      "mode": "NULLABLE",
      "description": "The id of the Subscription associated with the Usage.",
      "foreignKey": {
        "reference": "subscriptions.id",
        "relationshipName": "billed usage references subscription",
        "relationshipCardinality": "n,1"
      },
      "isPrimaryKey": false,
      "piiCategory": "CustomerNumber"
    },
    ...
  ]
}