What does Atlan crawl from MySQL?

Have more questions? Submit a request

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?
0 out of 0 found this helpful