> ## Documentation Index
> Fetch the complete documentation index at: https://trophy-ci-i18n-auto-translations.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Data sync

> Learn how to sync Trophy data to your warehouse or database for analytics and reporting.

<Note>
  Data Sync is only available on request. Please [get in touch](mailto:support@trophy.so) to discuss your needs.
</Note>

<h2 id="what-is-data-sync">
  What is Data Sync?
</h2>

Data sync allows you to connect Trophy to your data warehouse or database and set up an ongoing sync of Trophy data for analytics and reporting purposes. This enables teams to build custom queries across internal data in combination with data from Trophy.

<h2 id="supported-destinations">
  Supported Destinations
</h2>

Currently Trophy supports syncing data into Postgres databases.

<Tip>
  We're working on adding support for more destinations in the future. Please [get in touch](mailto:support@trophy.so) to discuss your needs.
</Tip>

<h2 id="connecting-your-destination">
  Connecting Your Destination
</h2>

Please [contact the support team](mailto:support@trophy.so) to connect your destination. We'll understand the specifics of your set up, help you create the necessary tables and create a secure connection.

Once connected, Trophy will backfill historical data for you and then continue to sync data once per hour.

<h2 id="supported-tables">
  Supported Tables
</h2>

Trophy supports syncing data into the following tables:

| Name                    | Destination Table Name           | Description                                             |
| ----------------------- | -------------------------------- | ------------------------------------------------------- |
| Metric totals           | `trophy_metric_totals`           | Total value of all metric events per day for each user. |
| Point totals            | `trophy_points_totals`           | Total value of all point awards per day for each user.  |
| Streak periods          | `trophy_streak_periods`          | Streak history for each user.                           |
| Streak freezes          | `trophy_streak_freezes`          | Streak freezes for each user.                           |
| Leaderboard rankings    | `trophy_leaderboard_rankings`    | Leaderboard positions per run.                          |
| Achievement completions | `trophy_achievement_completions` | Completed achievements for all users.                   |

New and updated data is synced to the respective tables once per hour.

<h2 id="get-support">
  Get Support
</h2>

Want to get in touch with the Trophy team? Reach out to us via [email](mailto:support@trophy.so). We're here to help!