Skip to main content

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 propertyAtlan property
TABLE_CATALOGname
SCHEMA_COUNTschemaCount

Schemas

Atlan maps schemas from PostgreSQL to its Schema asset type.

Source propertyAtlan property
TABLE_SCHEMAname
TABLE_COUNTtableCount
VIEW_COUNTviewsCount
TABLE_CATALOGdatabaseName

Tables

Atlan maps tables from PostgreSQL to its Table asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
TABLE_KIND (p), TABLE_TYPE (PARTITIONED TABLE)isPartitioned
PARTITION_STRATEGYpartitionStrategy
PARTITION_COUNTpartitionCount
IS_INSERTABLE_INTOis_insertable_into
IS_TYPEDis_typed
SELF_REFERENCING_COL_NAMEself_referencing_col_name
REF_GENERATIONref_generation
IS_TRANSIENTis_transient

Table partitions

Atlan maps table partitions from PostgreSQL to its TablePartition asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
PARTITION_CONSTRAINTconstraint
TABLE_KIND (p), TABLE_TYPE (PARTITIONED TABLE)isPartitioned
PARTITION_STRATEGYpartitionStrategy
PARTITION_COUNTpartitionCount
IS_INSERTABLE_INTOis_insertable_into
IS_TYPEDis_typed
SELF_REFERENCING_COL_NAMEself_referencing_col_name
REF_GENERATIONref_generation
IS_TRANSIENTis_transient

Views

Atlan maps views from PostgreSQL to its View asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
VIEW_DEFINITIONdefinition
IS_INSERTABLE_INTOis_insertable_into
IS_TYPEDis_typed
SELF_REFERENCING_COL_NAMEself_referencing_col_name
REF_GENERATIONref_generation
IS_TRANSIENTis_transient

Materialized views

Atlan maps materialized views from PostgreSQL to its MaterialisedView asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
VIEW_DEFINITIONdefinition

Columns

Atlan maps columns from PostgreSQL to its Column asset type.

Source propertyAtlan property
COLUMN_NAMEname
REMARKSdescription
ORDINAL_POSITIONorder
TYPE_NAMEdataType
NULLABLEisNullable
IS_PARTITIONisPartition
PARTITION_ORDERpartitionOrder
CONSTRAINT_TYPE (PRIMARY KEY)isPrimary
CONSTRAINT_TYPE (FOREIGN KEY)isForeign
DECIMAL_DIGITSprecision
NUMERIC_SCALEnumericScale
NUMERIC_PRECISIONnumeric_precision
IS_AUTOINCREMENTis_auto_increment
IS_GENERATEDis_generated
NUM_PREC_RADIXnum_prec_radix
IS_IDENTITYis_identity
IDENTITY_CYCLEidentity_cycle
IS_SELF_REFERENCINGis_self_referencing
ORDINAL_POSITIONordinal_position