Skip to content

Instantly share code, notes, and snippets.

@pietheinstrengholt

pietheinstrengholt/DataLandingZoneEntities.json

Last active December 28, 2021 16:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pietheinstrengholt/c4ebba685d851b7d9c2d81fefe78b663 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pietheinstrengholt/c4ebba685d851b7d9c2d81fefe78b663 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DataLandingZoneEntities.json
{
"entity": {
"status": "ACTIVE",
"createTime": 1592928847,
"updateTime": 1594120997,
"createdBy": "Superadmin",
"version": 1,
"attributes": {
"name": "SalesLTAddress",
"db": {
"guid": "-AdventureWorks",
"typeName": "data_landing_zone"
},
"qualifiedName": "AdventureWorks.SalesLTAddress",
"createTime": 1592928847,
"lastAccessTime": 1594120997,
"comment": "AdventureWorks sample database",
"tableType": "CSV",
"parameters": {
"Owner": "Superadmin",
"Region": "Europe",
"Type": "Merge",
"primaryKey": "AddressID"
},
"location": "https://synapsepiethein.dfs.core.windows.net/landingzone/AdventureWorks/Address.csv",
"description": "AdventureWorks sample database",
"owner": "Superadmin"
},
"columns": [
{
"guid": "-AdventureWorks.SalesLTAddress.AddressID",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.AddressLine1",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.AddressLine2",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.City",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.StateProvince",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.CountryRegion",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.PostalCode",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.rowguid",
"typeName": "column"
},
{
"guid": "-AdventureWorks.SalesLTAddress.ModifiedDate",
"typeName": "column"
}
],
"relationshipAttributes": {
"inputToProcesses": [],
"schema": [],
"attachedSchema": [],
"meanings": [],
"outputFromProcesses": [],
"tabular_schema": {
"guid": "-AdventureWorks.SalesLTAddress#__tabular_schema",
"typeName": "tabular_schema",
"entityStatus": "ACTIVE",
"displayText": "tabular_schema",
"relationshipType": "tabular_schema_datasets",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_datasets"
}
}
},
"typeName": "database_table",
"guid": "-AdventureWorks.SalesLTAddress"
},
"referredEntities": {
"-AdventureWorks": {
"status": "ACTIVE",
"createTime": 1594120983,
"createdBy": "Superadmin",
"version": 1,
"attributes": {
"qualifiedName": "AdventureWorks",
"name": "AdventureWorks",
"description": "AdventureWorks sample databases",
"parameters": {
"Owner": "Superadmin",
"Region": "Europe"
},
"location": "https://synapsepiethein.dfs.core.windows.net/landingzone/AdventureWorks/"
},
"typeName": "data_landing_zone",
"guid": "-AdventureWorks"
},
"-AdventureWorks.SalesLTAddress.AddressID": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.AddressID",
"name": "AddressID",
"type": "INT",
"comment": "AddressID",
"description": "AddressID",
"position": 1
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.AddressID"
},
"-AdventureWorks.SalesLTAddress.AddressLine1": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.AddressLine1",
"name": "AddressLine1",
"type": "STRING",
"comment": "AddressLine1",
"description": "AddressLine1",
"position": 2
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.AddressLine1"
},
"-AdventureWorks.SalesLTAddress.AddressLine2": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.AddressLine2",
"name": "AddressLine2",
"type": "STRING",
"comment": "AddressLine2",
"description": "AddressLine2",
"position": 3
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.AddressLine2"
},
"-AdventureWorks.SalesLTAddress.City": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.City",
"name": "City",
"type": "STRING",
"comment": "City",
"description": "City",
"position": 4
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.City"
},
"-AdventureWorks.SalesLTAddress.StateProvince": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.StateProvince",
"name": "StateProvince",
"type": "STRING",
"comment": "StateProvince",
"description": "StateProvince",
"position": 5
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.StateProvince"
},
"-AdventureWorks.SalesLTAddress.CountryRegion": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.CountryRegion",
"name": "CountryRegion",
"type": "STRING",
"comment": "CountryRegion",
"description": "CountryRegion",
"position": 6
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.CountryRegion"
},
"-AdventureWorks.SalesLTAddress.PostalCode": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.PostalCode",
"name": "PostalCode",
"type": "STRING",
"comment": "PostalCode",
"description": "PostalCode",
"position": 7
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.PostalCode"
},
"-AdventureWorks.SalesLTAddress.rowguid": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.rowguid",
"name": "rowguid",
"type": "STRING",
"comment": "rowguid",
"description": "rowguid",
"position": 8
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.rowguid"
},
"-AdventureWorks.SalesLTAddress.ModifiedDate": {
"typeName": "column",
"attributes": {
"owner": "Superadmin",
"qualifiedName": "AdventureWorks.SalesLTAddress.ModifiedDate",
"name": "ModifiedDate",
"type": "DATE",
"comment": "ModifiedDate",
"description": "ModifiedDate",
"position": 9
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress.ModifiedDate"
},
"-AdventureWorks.SalesLTAddress#__tabular_schema": {
"typeName": "tabular_schema",
"attributes": {
"owner": "root",
"qualifiedName": "AdventureWorks.SalesLTAddress#__tabular_schema",
"name": "tabular_schema",
"format": null,
"description": null
},
"status": "ACTIVE",
"updateTime": 1594120996,
"createdBy": "Superadmin",
"version": 1,
"guid": "-AdventureWorks.SalesLTAddress#__tabular_schema",
"relationshipAttributes": {
"inputToProcesses": [],
"schema": [],
"associatedDataSets": [
{
"guid": "-AdventureWorks.SalesLTAddress",
"typeName": "database_table",
"entityStatus": "ACTIVE",
"displayText": "Delta Table",
"relationshipType": "tabular_schema_datasets",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_datasets"
}
}
],
"columns": [
{
"guid": "-AdventureWorks.SalesLTAddress.AddressID",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "AddressID",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.AddressLine1",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "AddressLine1",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.AddressLine2",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "AddressLine2",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.City",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "City",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.StateProvince",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "StateProvince",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.CountryRegion",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "CountryRegion",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.PostalCode",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "PostalCode",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.rowguid",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "rowguid",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
},
{
"guid": "-AdventureWorks.SalesLTAddress.ModifiedDate",
"typeName": "column",
"entityStatus": "ACTIVE",
"displayText": "ModifiedDate",
"relationshipType": "tabular_schema_columns",
"relationshipStatus": "ACTIVE",
"relationshipAttributes": {
"typeName": "tabular_schema_columns"
}
}
],
"attachedSchema": [],
"meanings": [],
"outputFromProcesses": []
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment