The URN is an address which aims to identify uniquely an asset in a physical system. This address describes the type of the asset too, as its positioning in the hierarchy of the physical system, independently of its representation and organization in DataGalaxy.
This new identifier ease the harvesting of metadata and building an end-to-end lineage, connecting the technologies with each other.
The generic syntax of URN is like this:
urn:technology-urnVersion:object1Name@object1Type:object2Name @object2Type ...
The type of the object can be optional: it is useful if in the physical system, multiple object types can be found under the same parent object (for instance tables and views in a database). At each level, a default type is defined and will be considered as the implicit type of an object whose URN does not specify a type. This way, URN can be simplified:
urn:technology-urnVersion:object1Name:object2Name...
At first creation of an object in DataGalaxy using its URN, its path and typePath will be resolved based on the components of the URN, in order to put the object in the hierarchy. The URN of an object containing the URN of its parents, the platform will look for any parent the new object should be a children of. Once created, an object can be moved elsewhere in the hierarchy without impacting the capacity of updating it using its URN. This gives a lot of flexibility to organize the hierarchy of objects in the platform.
The new API endpoints available to manipulate DataGalaxy objects with their URN are describe in the online documentation of the API.
New technologies will be added to this page as we go along the definition of their URN convention.
Databases, datawarehouses, datalakes and other storages
MS SQL Server
Version URN : 1.
| Objet | URN |
|---|---|
| Database | urn:sqlserver-1:hostname%3Aport%2Fdatabase |
| Schema | urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema |
| Table | urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema:table |
| View | urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema:view@view |
| Column | urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema:table:column urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema:view@view:column |
| PK | urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema:table:pkConstraintName@primarykey |
| FK | urn:sqlserver-1:hostname%3Aport%2Fdatabase:schema@schema:table:fkName@foreignkey |
Azure SQL
Version URN : 1.
| Objet | URN |
|---|---|
| Database | urn:azuresql-1:hostname%3Aport%2Fdatabase |
| Schema | urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema |
| Table | urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema:table |
| View | urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema:view@view |
| Column | urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema:table:column urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema:view@view:column |
| PK | urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema:table:pkConstraintName@primarykey |
| FK | urn:azuresql-1:hostname%3Aport%2Fdatabase:schema@schema:table:fkName@foreignkey |
BigQuery
URN Version: 1.
| Object | URN |
|---|---|
| Project | urn:googlebigquery-1:projectId |
| Dataset | urn:googlebigquery-1:projectId:dataset |
| Table | urn:googlebigquery-1:projectId:dataset:table |
| View | urn:googlebigquery-1:projectId:dataset:view@view |
| Field | urn:googlebigquery-1:projectId:dataset:table:field*:field@field |
Databricks
URN Version: 1.
| Object | URN |
|---|---|
| Instance | urn:databricks-1:instance |
| Catalog | urn:databricks-1:instance:catalog |
| Schema | urn:databricks-1:instance:catalog:schema |
| Table | urn:databricks-1:instance:catalog:schema:table |
| View | urn:databricks-1:instance:catalog:schema:view@view |
| Column | urn:databricks-1:instance:catalog:schema:table:column urn:databricks-1:instance:catalog:schema:view@view:column |
| PK | urn:databricks-1:instance:catalog:schema:table:column:pkConstraintName@primarykey |
| FK | urn:databricks-1:instance:catalog:schema:table:column:fkName@foreignkey |
Snowflake
URN Version: 1.
| Object | URN |
|---|---|
| Account | urn:snowflake-1:accountName |
| Database | urn:snowflake-1:accountName:database |
| Schema | urn:snowflake-1:accountName:database:schema |
| Table | urn:snowflake-1:accountName:database:schema:table |
| View | urn:snowflake-1:accountName:database:schema:view@view |
| Dynamic Table | urn:snowflake-1:accountName:database:schema:dtable@dynamictable |
| Column | urn:snowflake-1:accountName:database:schema:table:column urn:snowflake-1:accountName:database:schema:view@view:column |
| PK | urn:snowflake-1:accountName:database:schema:table:column:pkConstraintName@primarykey |
| FK | urn:snowflake-1:accountName:database:schema:table:column:fkName@foreignkey |
BI tools, data visualization
Power BI
URN Version: 1.
| Object | URN |
|---|---|
| Workspace | urn:powerbi-1:tenantId:workspaceId urn:powerbi-1:tenantId:workspaceId@workspace |
| Application | urn:powerbi-1:tenantId:appId |
| Dashboard | urn:powerbi-1:tenantId:workspaceId@workspace:dashboardId@dashboard |
| DataSet | urn:powerbi-1:tenantId:workspaceId@workspace:datasetId@dataset |
| DataSet Table | urn:powerbi-1:tenantId:workspaceId@workspace:datasetId@dataset:tableName |
| DataSet Measure | urn:powerbi-1:tenantId:workspaceId@workspace:datasetId@dataset:tableName:measureName@measure |
| DataSet Column | urn:powerbi-1:tenantId:workspaceId@workspace:datasetId@dataset:tableName:columnName@column |
| DataFlow | urn:powerbi-1:tenantId:workspaceId@workspace:dataflowId@dataflow |
| DataFlow Entity | urn:powerbi-1:tenantId:workspaceId@workspace:dataflowId@dataflow:entityName |
| DataFlow Entity Attribute | urn:powerbi-1:tenantId:workspaceId@workspace:dataflowId@dataflow:entityName:attributeName |
| Report | urn:powerbi-1:tenantId:workspaceId@workspace:reportId urn:powerbi-1:tenantId:workspaceId@workspace:reportId@report |
| Report Page | urn:powerbi-1:tenantId:workspaceId@workspace:reportId@report:pageName |