What does Atlan crawl from MySQL?

Atlan crawls and maps the following assets and properties from MySQL.

Databases

Atlan maps databases from MySQL to its Database asset type.

Source property Atlan property
TABLE_CATALOG name
SCHEMA_COUNT schemaCount

Schemas

Atlan maps schemas from MySQL 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 MySQL to its Table asset type.

Source property Atlan property
TABLE_NAME name
REMARKS description
COLUMN_COUNT columnCount
ROW_COUNT rowCount
BYTES sizeBytes
TABLE_TYPE subType
IS_PARTITION isPartitioned
PARTITION_STRATEGY partitionStrategy
PARTITION_COUNT partitionCount
PARTITIONS partitionList
CREATE_TIME sourceCreatedAt

Views

Atlan maps views from MySQL to its View asset type.

Source property Atlan property
TABLE_NAME name
REMARKS description
COLUMN_COUNT columnCount
VIEW_DEFINITION definition
IS_PARTITION isPartitioned
PARTITION_COUNT partitionCount
CREATE_TIME sourceCreatedAt

Columns

Atlan maps columns from MySQL 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
IS_NULLABLE isNullable
NUMERIC_SCALE numericScale
CHARACTER_MAXIMUM_LENGTH maxLength

Stored procedures

Atlan maps stored procedures from MySQL to its Procedure asset type.

Source property Atlan property
PROCEDURE_NAME name
REMARKS description
PROCEDURE_TYPE subType
ROUTINE_DEFINITION definition
CREATED sourceCreatedAt
LAST_ALTERED sourceUpdatedAt

Related articles

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