## What does Atlan crawl from Microsoft SQL Server?

URL: https://docs.atlan.com/apps/connectors/database/microsoft-sql-server/references/what-does-atlan-crawl-from-microsoft-sql-server

> Atlan crawls and maps the following assets and properties from Microsoft SQL Server.

Atlan crawls and maps the following assets and properties from Microsoft SQL Server.

## Databases

Atlan maps databases from Microsoft SQL Server to its `Database` asset type.

| Source property | Atlan property | Where in Atlan |
| --- | --- | --- |
| `TABLE_CATALOG` | `name` | asset preview, profile, and filter, overview sidebar |
| `SCHEMA_COUNT` | `schemaCount` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |

## Schemas

Atlan maps schemas from Microsoft SQL Server to its `Schema` asset type.

| Source property | Atlan property | Where in Atlan |
| --- | --- | --- |
| `TABLE_SCHEMA` | `name` | asset preview, profile, and filter, overview sidebar |
| `TABLE_COUNT` | `tableCount` | asset preview and profile |
| `VIEW_COUNT` | `viewsCount` | asset preview and profile |
| `TABLE_CATALOG` | `databaseName` | asset preview and profile |

## Tables

Atlan maps tables from Microsoft SQL Server to its `Table` asset type.

| Source property | Atlan property | Where in Atlan |
| --- | --- | --- |
| `TABLE_NAME` | `name` | asset preview, profile, and filter, overview sidebar |
| `REMARKS` | `description` | asset preview, profile, and filter, overview sidebar |
| `COLUMN_COUNT` | `columnCount` | asset preview, profile, and filter, overview sidebar |
| `ROW_COUNT` | `rowCount` | asset preview, profile, and filter, overview sidebar |
| `BYTES` | `sizeBytes` | asset preview, profile, and filter, overview sidebar |
| `PARTITIONS` | `isPartitioned` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |
| `PARTITION_COUNT` | `partitionCount` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |

## Views

Atlan maps views from Microsoft SQL Server to its `View` asset type.

| Source property | Atlan property | Where in Atlan |
| --- | --- | --- |
| `TABLE_NAME` | `name` | asset preview, profile, and filter, overview sidebar |
| `REMARKS` | `description` | asset preview, profile, and filter, overview sidebar |
| `COLUMN_COUNT` | `columnCount` | asset preview, profile, and filter, overview sidebar |
| `VIEW_DEFINITION (WITH SCHEMABINDING)` | `isClustered` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |
| `VIEW_DEFINITION` | `definition` | asset profile and overview sidebar |

## Columns

Atlan maps columns from Microsoft SQL Server to its `Column` asset type.

| Source property | Atlan property | Where in Atlan |
| --- | --- | --- |
| `COLUMN_NAME` | `name` | asset preview, profile, and filter, overview sidebar |
| `REMARKS` | `description` | asset preview, profile, and filter, overview sidebar |
| `ORDINAL_POSITION` | `order` | asset profile |
| `TYPE_NAME` | `dataType` | asset preview, profile, and filter, overview sidebar |
| `CONSTRAINT_TYPE (PRIMARY KEY)` | `isPrimary` | asset preview, profile, and filter |
| `CONSTRAINT_TYPE (FOREIGN KEY)` | `isForeign` | asset preview, profile, and filter |
| `NULLABLE` | `isNullable` | asset profile and overview sidebar |
| `NUMERIC_SCALE` | `numericScale` | asset profile and overview sidebar |
| `NUMERIC_PRECISION` | `precision` | asset profile and overview sidebar |

## Routines

Atlan maps routines in Microsoft SQL Server to its `Procedure` asset type. These assets are currently neither published nor discoverable in Atlan.

| Source property | Atlan property | Where in Atlan |
| --- | --- | --- |
| `ROUTINE_NAME` | `name` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |
| `REMARKS` | `description` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |
| `PROCEDURE_TYPE` | `subType` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |
| `ROUTINE_DEFINITION` | `definition` | [API only](https://docs.atlan.com/llms/governance/faq/data-connections-and-integration/llms.txt) |

---