What does Atlan crawl from PostgreSQL?

Atlan crawls and maps the following assets and properties from PostgreSQL.

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`

Atlan maps schemas from PostgreSQL to its Schema asset type.

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`

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`

Atlan maps views from PostgreSQL to its View asset type.

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

Atlan maps columns from PostgreSQL to its Column asset type.

Source property	Atlan property
`COLUMN_NAME`	`name`
`REMARKS`	`description`