What does Atlan crawl from MySQL?
During a MySQL crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Stored Procedures and maps it to Atlan's internal asset model. The tables below list, for each asset type, which MySQL properties are read and how they appear on the corresponding Atlan asset.
Once you have crawled MySQL, you can use connector-specific filters for quick asset discovery.
Databases
Atlan maps databases from MySQL to its Database asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLE_CATALOG | name | asset preview and profile, overview sidebar |
SCHEMA_COUNT | schemaCount | asset filters |
Schemas
Atlan maps schemas from MySQL to its Schema asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLE_SCHEMA | name | asset preview and profile, overview sidebar |
TABLE_COUNT | tableCount | asset preview and profile |
VIEW_COUNT | viewsCount | asset preview and profile |
TABLE_CATALOG | databaseName | asset preview and profile, overview sidebar |
Tables
Atlan maps tables from MySQL to its Table asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLE_NAME | name | asset preview and profile, overview sidebar |
REMARKS | description | asset preview and profile, overview sidebar |
COLUMN_COUNT | columnCount | asset preview and profile, overview sidebar |
ROW_COUNT | rowCount | asset preview and profile, overview sidebar |
BYTES | sizeBytes | asset preview and profile, overview sidebar |
TABLE_TYPE | subType | API only |
IS_PARTITION | isPartitioned | API only |
PARTITION_STRATEGY | partitionStrategy | API only |
PARTITION_COUNT | partitionCount | API only |
PARTITIONS | partitionList | API only |
CREATE_TIME | sourceCreatedAt | asset preview and profile, properties sidebar |
Views
Atlan maps views from MySQL to its View asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
TABLE_NAME | name | asset preview and profile, overview sidebar |
REMARKS | description | asset preview and profile, overview sidebar |
COLUMN_COUNT | columnCount | asset preview and profile, overview sidebar |
VIEW_DEFINITION | definition | asset profile and overview sidebar |
IS_PARTITION | isPartitioned | API only |
PARTITION_COUNT | partitionCount | API only |
CREATE_TIME | sourceCreatedAt | asset preview and profile, properties sidebar |
Columns
Atlan maps columns from MySQL to its Column asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
COLUMN_NAME | name | asset profile and filter, overview sidebar |
REMARKS | description | asset profile and filter, overview sidebar |
ORDINAL_POSITION | order | parent asset profile |
TYPE_NAME | dataType | asset preview and filter, overview sidebar, parent asset profile |
CONSTRAINT_TYPE (PRIMARY KEY) | isPrimary | asset preview and filter, overview sidebar, parent asset profile |
CONSTRAINT_TYPE (FOREIGN KEY) | isForeign | asset preview and filter, overview sidebar, parent asset profile |
IS_NULLABLE | isNullable | API only |
NUMERIC_SCALE | numericScale | API only |
CHARACTER_MAXIMUM_LENGTH | maxLength | API only |
Stored procedures
Atlan maps stored procedures from MySQL to its Procedure asset type.
| Source property | Atlan property | Where in Atlan |
|---|---|---|
PROCEDURE_NAME | name | API only |
REMARKS | description | API only |
PROCEDURE_TYPE | subType | API only |
ROUTINE_DEFINITION | definition | API only |
CREATED | sourceCreatedAt | API only |
LAST_ALTERED | sourceUpdatedAt | API only |