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