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