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