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 |
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 |
PARTITION_COUNT |
partitionCount |
API only |
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 |
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 |
REMARKS |
description |
API only |
PROCEDURE_TYPE |
subType |
API only |
ROUTINE_DEFINITION |
definition |
API only |