What does Atlan crawl from Microsoft Azure Synapse Analytics?
Atlan extracts metadata for Databases, Schemas, Tables, Views, and Routines from Microsoft Azure Synapse Analytics and maps each property to its internal asset model. The tables below list which Microsoft Azure Synapse Analytics properties are read and how they appear on the corresponding Atlan asset. Atlan also supports view-level lineage and cross-source lineage between BI tools and SQL sources.
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 |