What does Atlan crawl from PostgreSQL?

Have more questions? Submit a request

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

Related articles

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