What does Atlan crawl from MySQL?
Atlan crawls and maps the following assets and properties from MySQL.
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 |