What does Atlan crawl from PostgreSQL?
Atlan crawls and maps the following assets and properties from PostgreSQL.
Databases
Atlan maps databases from PostgreSQL to its Database
asset type.
Source property | Atlan property |
---|---|
TABLE_CATALOG | name |
SCHEMA_COUNT | schemaCount |
Schemas
Atlan maps schemas from PostgreSQL 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 PostgreSQL to its Table
asset type.
Source property | Atlan property |
---|---|
TABLE_NAME | name |
REMARKS | description |
COLUMN_COUNT | columnCount |
ROW_COUNT | rowCount |
BYTES | sizeBytes |
TABLE_KIND (p) , TABLE_TYPE (PARTITIONED TABLE) | isPartitioned |
PARTITION_STRATEGY | partitionStrategy |
PARTITION_COUNT | partitionCount |
IS_INSERTABLE_INTO | is_insertable_into |
IS_TYPED | is_typed |
SELF_REFERENCING_COL_NAME | self_referencing_col_name |
REF_GENERATION | ref_generation |
IS_TRANSIENT | is_transient |
Table partitions
Atlan maps table partitions from PostgreSQL to its TablePartition
asset type.
Source property | Atlan property |
---|---|
TABLE_NAME | name |
REMARKS | description |
COLUMN_COUNT | columnCount |
ROW_COUNT | rowCount |
BYTES | sizeBytes |
PARTITION_CONSTRAINT | constraint |
TABLE_KIND (p) , TABLE_TYPE (PARTITIONED TABLE) | isPartitioned |
PARTITION_STRATEGY | partitionStrategy |
PARTITION_COUNT | partitionCount |
IS_INSERTABLE_INTO | is_insertable_into |
IS_TYPED | is_typed |
SELF_REFERENCING_COL_NAME | self_referencing_col_name |
REF_GENERATION | ref_generation |
IS_TRANSIENT | is_transient |
Views
Atlan maps views from PostgreSQL to its View
asset type.
Source property | Atlan property |
---|---|
TABLE_NAME | name |
REMARKS | description |
COLUMN_COUNT | columnCount |
VIEW_DEFINITION | definition |
IS_INSERTABLE_INTO | is_insertable_into |
IS_TYPED | is_typed |
SELF_REFERENCING_COL_NAME | self_referencing_col_name |
REF_GENERATION | ref_generation |
IS_TRANSIENT | is_transient |
Materialized views
Atlan maps materialized views from PostgreSQL to its MaterialisedView
asset type.
Source property | Atlan property |
---|---|
TABLE_NAME | name |
REMARKS | description |
COLUMN_COUNT | columnCount |
ROW_COUNT | rowCount |
BYTES | sizeBytes |
VIEW_DEFINITION | definition |
Columns
Atlan maps columns from PostgreSQL to its Column
asset type.
Source property | Atlan property |
---|---|
COLUMN_NAME | name |
REMARKS | description |
ORDINAL_POSITION | order |
TYPE_NAME | dataType |
NULLABLE | isNullable |
IS_PARTITION | isPartition |
PARTITION_ORDER | partitionOrder |
CONSTRAINT_TYPE (PRIMARY KEY) | isPrimary |
CONSTRAINT_TYPE (FOREIGN KEY) | isForeign |
DECIMAL_DIGITS | precision |
NUMERIC_SCALE | numericScale |
NUMERIC_PRECISION | numeric_precision |
IS_AUTOINCREMENT | is_auto_increment |
IS_GENERATED | is_generated |
NUM_PREC_RADIX | num_prec_radix |
IS_IDENTITY | is_identity |
IDENTITY_CYCLE | identity_cycle |
IS_SELF_REFERENCING | is_self_referencing |
ORDINAL_POSITION | ordinal_position |