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 |
