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

Related articles

Was this article helpful?
1 out of 1 found this helpful