What does Atlan crawl from Microsoft Azure Synapse Analytics?

Have more questions? Submit a request

Atlan crawls and maps the following assets and properties from Microsoft Azure Synapse Analytics.

πŸ’ͺ Did you know? Atlan currently only supports crawling dedicated SQL pools (formerly SQL DW) with the Microsoft Azure Synapse Analytics package.

Databases

Atlan maps databases from Microsoft Azure Synapse Analytics to its Database asset type.

Source property Atlan property
TABLE_CATALOG name
SCHEMA_COUNT schemaCount

Schemas

Atlan maps schemas from Microsoft Azure Synapse Analytics to its Schema asset type.

Source property Atlan property
TABLE_SCHEMA name
TABLE_COUNT tableCount
VIEW_COUNT viewsCount
TABLE_CATALOG databaseName

Tables

Atlan maps tables from Microsoft Azure Synapse Analytics to its Table asset type.

Source property Atlan property
TABLE_NAME name
REMARKS description
COLUMN_COUNT columnCount
ROW_COUNT rowCount
BYTES sizeBytes
PARTITIONS isPartitioned
PARTITION_COUNT partitionCount

Views

Atlan maps views from Microsoft Azure Synapse Analytics to its View asset type.

Source property Atlan property
VIEW_NAME name
REMARKS description
COLUMN_COUNT columnCount
VIEW_DEFINITION (WITH SCHEMABINDING) isClustered
VIEW_DEFINITION definition

Columns

Atlan maps columns from Microsoft Azure Synapse Analytics to its Column asset type.

Source property Atlan property
COLUMN_NAME name
REMARKS description
ORDINAL_POSITION order
TYPE_NAME dataType
CONSTRAINT_TYPE (PRIMARY KEY) isPrimary
CONSTRAINT_TYPE (FOREIGN KEY) isForeign
NULLABLE isNullable
NUMERIC_SCALE numericScale
NUMERIC_PRECISION precision

Routines

Atlan maps routines in Microsoft Azure Synapse Analytics to its Procedure asset type.

Source property Atlan property
ROUTINE_NAME name
REMARKS description
PROCEDURE_TYPE subType
ROUTINE_DEFINITION definition

Related articles

Was this article helpful?
0 out of 0 found this helpful