BigQuery URI format

URI definition for BigQuery follows this standard:

Identifier fragments:

  • Namespace: bigquery:
    • Scheme = bigquery
    • Authority = no authority
  • Unique name: {projectId}.{dataset name}.{table name}

URI format:

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

Parameters 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 letter, uppercase letter, 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)

Examples:

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