What does Atlan crawl from PostgreSQL?

Updated November 27, 2023 14:11

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`

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.