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 |
