What does Atlan crawl 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

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

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
`PARTITION_COUNT`	`partitionCount`	API only

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
`VIEW_DEFINITION`	`definition`	asset profile and overview sidebar

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

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