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 | 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 |