What does Atlan crawl from Microsoft SQL Server?

Have more questions? Submit a request

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
TABLE_CATALOG name
SCHEMA_COUNT schemaCount

Schemas

Atlan maps schemas from Microsoft SQL Server 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 SQL Server 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 SQL Server to its View asset type.

Source property Atlan property
TABLE_NAME name
REMARKS description
COLUMN_COUNT columnCount
VIEW_DEFINITION (WITH SCHEMABINDING) isClustered
VIEW_DEFINITION definition

Columns

Atlan maps columns from Microsoft SQL Server 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 SQL Server to its Procedure asset type.

Source property Atlan property
ROUTINE_NAME name
REMARKS description
PROCEDURE_TYPE subType
ROUTINE_DEFINITION definition

Related articles

Was this article helpful?
0 out of 0 found this helpful