Skip to main content

What does Atlan crawl from AlloyDB for PostgreSQL

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

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

Databases

Atlan maps databases from AlloyDB for PostgreSQL to its Database asset type.

Source propertyAtlan property
TABLE_CATALOGname
SCHEMA_COUNTschemaCount

Schemas

Atlan maps schemas from AlloyDB for PostgreSQL to its Schema asset type.

Source propertyAtlan property
TABLE_SCHEMAname
TABLE_COUNTtableCount
VIEW_COUNTviewsCount
TABLE_CATALOGdatabaseName

Tables

Atlan maps tables from AlloyDB for PostgreSQL to its Table asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
TABLE_KIND (p), TABLE_TYPE (PARTITIONED TABLE)isPartitioned
PARTITION_STRATEGYpartitionStrategy
PARTITION_COUNTpartitionCount
IS_INSERTABLE_INTOis_insertable_into
IS_TYPEDis_typed
SELF_REFERENCING_COL_NAMEself_referencing_col_name

Table partitions

Atlan maps table partitions from AlloyDB for PostgreSQL to its TablePartition asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
PARTITION_CONSTRAINTconstraint
TABLE_KIND (p), TABLE_TYPE (PARTITIONED TABLE)isPartitioned
PARTITION_STRATEGYpartitionStrategy
PARTITION_COUNTpartitionCount
IS_INSERTABLE_INTOis_insertable_into
IS_TYPEDis_typed
SELF_REFERENCING_COL_NAMEself_referencing_col_name

Views

Atlan maps views from AlloyDB for PostgreSQL to its View asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
VIEW_DEFINITIONdefinition
IS_INSERTABLE_INTOis_insertable_into
IS_TYPEDis_typed
SELF_REFERENCING_COL_NAMEself_referencing_col_name

Materialized views

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

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
VIEW_DEFINITIONdefinition

Columns

Atlan maps columns from AlloyDB for PostgreSQL to its Column asset type.

Source propertyAtlan property
COLUMN_NAMEname
REMARKSdescription
constraint_typeisPrimary
constraint_typeisForeign
ordinalorder