BigQuery URI Format

The Uniform Resource Identifier (URI) definition for BigQuery follows this standard:

Identifier Fragments

• Namespace: bigquery:
  • Scheme = bigquery
  • Authority = no authority
• Unique name: {projectId}.{datasetName}.{tableName}

Asset URI Format

• bigquery:{projectId}.{datasetName}.{tableName}

BigQuery Dataset URI Format

• bigquery:{projectId}.{datasetName}

Parameter Limitations

• projectId identifier must start with a lowercase letter and include only lowercase letters, numbers and dash, and finish with a letter or a number (regex: [a-z][a-z0-9-]*[a-z0-9])
• datasetName identifier must include only lowercase letters, uppercase letters, numbers and underscore (regex: [a-zA-Z0-9_]+ )
• tableName identifier must include only characters included in those Unicode categories L (letter), M (mark), N (number), Pc (connector, including underscore), Pd (dash), Zs (space) (see https://en.wikipedia.org/wiki/Unicode_character_property for details about Unicode categories)

Asset Examples

• bigquery:sifflet-demo-project.sandbox_dataset.cbsa_2008_1yr
• bigquery:demo-18.dev_data.таблица
• bigquery:project-dev.DATASET_SAMPLE.TABLE

BigQuery Dataset Examples

• bigquery:sifflet-demo-project.sandbox_dataset
• bigquery:demo-18.dev_data
• bigquery:project-dev.DATASET_SAMPLE