dbt URI format

For a dbt Core instance:

Identifier fragments:

• Namespace: dbt:
  • Scheme = dbt
  • Authority = no authority
• Unique name: {projectName}.{target}.{modelName}

URI format:

• dbt:{projectName}.{target}.{modelName}

Parameters limitations:

• all unique name identifiers must include only lowercases, uppercases, numbers, dash and underscore (regex:[a-zA-Z0-9_-]+)

Example:

• dbt:dbt_test_project_postgres.dev.model_name

For a dbt Cloud instance:

Identifier fragments:

• Namespace: dbt:
  • Scheme = dbt
  • Authority = {accountId}
• Unique name: {projectId}.{jobId}.{modelName}

URI format:

• dbt://{accountId}/{projectId}.{jobId}.{modelName}

Parameters limitations:

• accountId identifier must include only numbers
• all unique name identifiers must include only lowercases, uppercases, numbers, dash and underscore (regex:[a-zA-Z0-9_-]+)

Example:

• dbt://4726832/75756aA.6A0444.model4