## What does Atlan crawl from Hightouch?

URL: https://docs.atlan.com/apps/connectors/etl-tools/hightouch/references/what-does-atlan-crawl-from-hightouch

> Learn what assets and metadata Atlan extracts from Hightouch reverse ETL pipelines and syncs.

Atlan crawls and maps the following assets and properties from Hightouch. Atlan establishes comprehensive lineage between your data warehouse sources and operational business tools by parsing Hightouch metadata.

- Hightouch Models
- Hightouch Syncs
- Column-level lineage between source and target systems

Atlan's Hightouch connectivity creates lineage flows that show how data moves from your warehouse through Hightouch models and syncs to operational business tools.

## Models

Models define and organize the data that gets queried from source systems.

| Source property | Atlan property | Where in Atlan |
|----------------|----------------|----------------|
| `name` | `name` | asset profile and overview sidebar |
| `description` | `description` | asset profile and overview sidebar |
| `createdAt` | `sourceCreatedAt` | asset profile and properties sidebar |
| `updatedAt` | `sourceUpdatedAt` | asset profile and properties sidebar |

:::info Model Types
Atlan supports two Hightouch model types:
- **SQL Editor**: Models defined with custom SQL queries. Atlan parses the SQL to establish upstream lineage to source tables and columns.
- **Table Selector**: Models that point directly to source tables. Atlan establishes lineage to the referenced table.
:::

## Syncs

Syncs define how queried results from models are mapped to destination systems.

| Source property | Atlan property | Where in Atlan |
|----------------|----------------|----------------|
| `name` | `name` | asset profile and overview sidebar |
| `description` | `description` | asset profile and overview sidebar |
| `status` | `flowStatus` | asset filter and overview sidebar |
| `lastRunAt` | `flowRunId` | overview sidebar |
| `createdAt` | `sourceCreatedAt` | asset profile and properties sidebar |
| `updatedAt` | `sourceUpdatedAt` | asset profile and properties sidebar |

:::info Sync Types
Atlan focuses on Object-type syncs, which map model data to destination objects. Field mapping configurations establish column-level lineage between source and target fields.
:::

## What lineage does Atlan extract from Hightouch

Atlan establishes comprehensive lineage by parsing Hightouch metadata:

### Upstream lineage (Source to Model)

- **SQL Models**: Parses SQL queries to identify referenced tables, views, and columns
- **Table Models**: Directly links to referenced source tables
- **Column-level Lineage**: Establishes source columns to model columns relationships where possible

### Downstream lineage (Model to Destination)

- **Field Mappings**: Interprets sync configuration to link model columns to destination fields
- **Standard Mappings**: Direct field-to-field relationships
- **Template Mappings**: Parses Liquid templating to identify referenced source fields

## See also

* [Set up Hightouch](https://docs.atlan.com/llms/connectors/hightouch/set-up-hightouch/llms.txt): Configure authentication using Hightouch API key
* [Crawl Hightouch](https://docs.atlan.com/llms/connectors/hightouch/crawl-hightouch/llms.txt): Configure and run the crawler to extract metadata from Hightouch

---