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 property | Atlan property |
---|---|
TABLE_CATALOG | name |
SCHEMA_COUNT | schemaCount |
Schemas
Atlan maps schemas from Cloud SQL for 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 Cloud SQL for 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 Cloud SQL for 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 Cloud SQL for 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 Cloud SQL for 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 Cloud SQL for PostgreSQL to its Column
asset type.
Source property | Atlan property |
---|---|
COLUMN_NAME | name |
REMARKS | description |