> ## Documentation Index
> Fetch the complete documentation index at: https://docs.imageprint.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data warehouse connectors

> Stream or batch sync data to your data warehouse.

Data warehouse connectors move data from your workspace into your warehouse for long-term storage, advanced analytics, and joining with other datasets.

## Supported warehouses

* Snowflake
* Google BigQuery
* Amazon Redshift
* Databricks (Delta Lake)
* Azure Synapse Analytics

## Connection setup

<Steps>
  <Step title="Create a destination in the warehouse">
    In your warehouse, create a dedicated database and schema for the platform's data. Create a service account or user with write access to that schema. Avoid using root or admin credentials.
  </Step>

  <Step title="Add the warehouse connection">
    Go to **Integrations → Catalog → Data warehouses**, select your warehouse type, and enter the connection details:

    * **Host / account identifier** (Snowflake uses account identifiers; others use hostnames)
    * **Database and schema**
    * **Username and password or service account credentials**
  </Step>

  <Step title="Configure table settings">
    Choose which entities to sync to the warehouse (projects, reports, analytics events, audit logs). Each entity maps to one table in the destination schema. Table names are pre-set and cannot be changed.
  </Step>

  <Step title="Test and activate">
    Click **Test connection** to validate credentials and write access. Once the test passes, click **Activate** to start syncing.
  </Step>
</Steps>

## Table configuration

Each synced entity creates one table in the destination schema. Tables use an append-only or upsert write strategy depending on the entity type:

| Entity                   | Write strategy                       |
| ------------------------ | ------------------------------------ |
| Events and audit logs    | Append-only                          |
| Projects, users, reports | Upsert (update on primary key match) |

Columns follow a predictable naming convention: `snake_case`, with timestamps as UTC ISO 8601 strings.

<Info>
  Warehouse syncs run on a scheduled basis (minimum 1-hour intervals). Real-time streaming to warehouses is not currently supported.
</Info>