Skip to main content

What does Atlan crawl from Cloud SQL for PostgreSQL

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

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

Databases

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

Source propertyAtlan property
TABLE_CATALOGname
SCHEMA_COUNTschemaCount

Schemas

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

Source propertyAtlan property
TABLE_SCHEMAname
TABLE_COUNTtableCount
VIEW_COUNTviewsCount
TABLE_CATALOGdatabaseName

Tables

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

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
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
REF_GENERATIONref_generation
IS_TRANSIENTis_transient

Table partitions

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

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
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
REF_GENERATIONref_generation
IS_TRANSIENTis_transient

Views

Atlan maps views from Cloud SQL 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
REF_GENERATIONref_generation
IS_TRANSIENTis_transient

Materialized views

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

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
VIEW_DEFINITIONdefinition

Columns

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

Source propertyAtlan property
COLUMN_NAMEname
REMARKSdescription