## What does Atlan crawl from Microsoft Azure Synapse Analytics?

URL: https://docs.atlan.com/apps/connectors/data-warehouses/microsoft-azure-synapse-analytics/references/what-does-atlan-crawl-from-microsoft-azure-synapse-analytics

> During a Microsoft Azure Synapse Analytics crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Routines. Reference tables map each Azure Synapse property to its Atlan asset.

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 |

---