Universal Resource Identifier (URI)

The Universal Resource Identifier (URI) is the unique identifier for every resource within the mapped data model. The URI is used to map the location of resources within the data model, and their connections.

The main role of the URI is to establish relationships between two resources. To illustrate with an example:

Suppose the data model has a database table with URI snowflake.us_west_2.abcd1234.my_database.my_schema.my_table . On the next run of the snowflake integration, a new view is observed at snowflake.us_west_2.abcd1234.my_database.my_schema.my_view, and that view depends on snowflake.us_west_2.abcd1234.my_database.my_schema.my_table, in this case, a relationship of type "depends" will be established between the view and the table.

The following describes the structure of the URI for each resource type

URI formats by type

platform

URI structure: platform.<PLATFORM TYPE>.<PLATFORM IDENTIFIER>

Examples: platform.snowflake.abcd1234

table

URI structure:

Depending on the database technology, the URI takes one of two forms:

  • <TECHNOLOGY>.<PLATFORM IDENTIFIER>.<DATABASE>.<SCHEMA>.<TABLE NAME>

  • <TECHNOLOGY>.<PLATFORM IDENTIFIER>.<SCHEMA>.<TABLE NAME>

Examples:

  • bigquery.my_project.my_dataset.my_table

  • mysql.mysql_domain.com.my_schema.my_table

  • aws_glue.aws_account_identifier.aws_region.my_glue_catalog_identifier.my_schema.my_table

looker folder

URI structure: looker.<LOOKER HOST>.folder.<LOOKER ID>

Examples: looker.my_looker_domain.folder.1001

Terms:

  • TECHNOLOGY: the technology of the platform. i.e. 'snowflake', 'bigquery', 'mysql', etc.

  • PLATFORM IDENTIFIER: a platform-type-specific identifier that uniquely identifies the platform. For example, for Snowflake, this would be the snowflake account id.

  • DATABASE: the name of the database the table is in. In some databases, this level of the hierarchy is called "catalog".

  • SCHEMA: the name of the schema the table is in. In some databases, this level of the hierarchy is called "database".

  • TABLE NAME: the table's name.

  • LOOKER ID: each resource in Looker has a unique id.

  • PLATFORM TYPE: the type of the platform. i.e. 'snowflake', 'tableau_site', 'mysql', etc.

Last updated