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 |