## What does Atlan crawl from Amazon Redshift?

URL: https://docs.atlan.com/apps/connectors/data-warehouses/amazon-redshift/references/what-does-atlan-crawl-from-amazon-redshift

> During an Amazon Redshift crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Columns. Reference tables map each Redshift property to its Atlan asset.

Atlan extracts metadata for Databases, Schemas, Tables, Views, and Columns from Amazon Redshift and maps each property to its internal asset model. The tables below list which Amazon Redshift properties are read and how they appear on the corresponding Atlan asset.

## Databases

Atlan maps databases from Amazon Redshift to its `Database` asset type.

| Source property | Atlan property |
| --- | --- |
| DATABASE\_NAME | name |
| SCHEMA\_COUNT | schemaCount |

## Schemas

Atlan maps schemas from Amazon Redshift to its `Schema` asset type.

| Source property | Atlan property |
| --- | --- |
| TABLE\_SCHEMA | name |
| TABLE\_COUNT | tableCount |
| VIEW\_COUNT | viewsCount |
| DATABASE\_NAME | databaseName |
| OWNER | sourceCreatedBy |
| SCHEMA\_TYPE | subType |

## Tables

Atlan maps tables from Amazon Redshift to its `Table` asset type.

| Source property | Atlan property |
| --- | --- |
| TABLE\_NAME | name |
| REMARKS | description |
| COLUMN\_COUNT | columnCount |
| ROW\_COUNT | rowCount |
| BYTES | sizeBytes |
| TABLE\_TYPE (EXTERNAL TABLE) | subType |
| LOCATION | externalLocation |
| INPUT\_FORMAT | externalLocationFormat |
| TABLE\_OWNER | sourceCreatedBy |
| CREATED | sourceCreatedAt |

## Views

Atlan maps views from Amazon Redshift to its `View` and `MaterialisedView` asset types.

| Source property | Atlan property |
| --- | --- |
| TABLE\_NAME | name |
| REMARKS | description |
| COLUMN\_COUNT | columnCount |
| VIEW\_DEFINITION | definition |
| TABLE\_OWNER | sourceCreatedBy |

## Columns

Atlan maps columns from Amazon Redshift to its `Column` asset type.

| Source property | Atlan property |
| --- | --- |
| COLUMN\_NAME | name |
| REMARKS | description |
| ORDINAL\_POSITION | order |
| TYPE\_NAME | dataType |
| NOTNULL | isNullable |
| CHARACTER\_MAXIMUM\_LENGTH | maxLength |
| DECIMAL\_DIGITS | precision |
| CONSTRAINT\_TYPE (PRIMARY KEY) | isPrimary |
| CONSTRAINT\_TYPE (FOREIGN KEY) | isForeign |
| SORTKEY | isSort |
| DISKEY | isDist |

---