What does Atlan crawl from PrestoSQL?
Atlan crawls and maps the following assets and properties from PrestoSQL.
Did you know?
Atlan currently only supports PrestoSQL until version 349. PrestoDB is not supported at present.
Databases
Atlan maps databases from PrestoSQL to its Database asset type.
| Source property | Atlan property |
|---|---|
| TABLE_CATALOG | name |
| SCHEMA_COUNT | schemaCount |
Schemas
Atlan maps schemas from PrestoSQL 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 PrestoSQL to its Table asset type.
| Source property | Atlan property |
|---|---|
| TABLE_NAME | name |
| REMARKS | description |
| COLUMN_COUNT | columnCount |
| ROW_COUNT | rowCount |
| BYTES | sizeBytes |
Views
Atlan maps views from PrestoSQL to its View asset type.
| Source property | Atlan property |
|---|---|
| TABLE_NAME | name |
| REMARKS | description |
| COLUMN_COUNT | columnCount |
| EXTRA_INFO (CREATE VIEW) | definition |
Columns
Atlan maps columns from PrestoSQL to its Column asset type.
| Source property | Atlan property |
|---|---|
| COLUMN_NAME | name |
| REMARKS | description |
| ORDINAL_POSITION | order |
| TYPE_NAME | dataType |
| NULLABLE | isNullable |
| DECIMAL_DIGITS | precision |
| NUMERIC_SCALE | numericScale |
Stored procedures
Atlan maps stored procedures in PrestoSQL to its Procedure asset type.
| Source property | Atlan property |
|---|---|
| PROCEDURE_NAME | name |
| REMARKS | description |
| PROCEDURE_TYPE | subType |
| ROUTINE_DEFINITION | definition |