## What does Atlan crawl from Cloud SQL for PostgreSQL

URL: https://docs.atlan.com/apps/connectors/database/cloud-sql/postgresql/references/what-does-atlan-crawl-from-cloud-sql-postgresql

> Atlan crawls and maps the following assets and properties 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](https://docs.atlan.com/llms/connectors/cloud-sql-postgresql/crawl-cloud-sql-postgresql/llms.txt), you can [use connector-specific filters](https://docs.atlan.com/llms/catalog/discovery/use-the-filters-menu/llms.txt) 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`

---