What does Atlan crawl from PostgreSQL?

During a PostgreSQL crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Functions and maps it to Atlan's internal asset model. The tables below list, for each asset type, which PostgreSQL properties are read and how they appear on the corresponding Atlan asset.

Once you have crawled PostgreSQL, you can use connector-specific filters for quick asset discovery.

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