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

# Fivetran

> Sync Rootly incident, alert, and metrics data to your data warehouse via Fivetran for custom analytics, BI dashboards, and long-term reliability reporting.

## Overview

Fivetran is a no-code data movement platform that syncs your Rootly incident data directly into your data warehouse. Once connected, you can query incident data alongside the rest of your business metrics in any BI tool.

<CardGroup cols={2}>
  <Card title="Warehouse Sync" icon="database">
    Pull Rootly incidents, workflows, roles, and more into Snowflake, BigQuery, Redshift, or any Fivetran-supported destination.
  </Card>

  <Card title="Custom Dashboards" icon="chart-bar">
    Build tailored visualizations and executive reports in your BI tool of choice — beyond what Rootly's built-in analytics provide.
  </Card>

  <Card title="Cross-Data Analysis" icon="arrows-split-up-and-left">
    Join Rootly incident data with other business metrics for deeper trend analysis and forecasting.
  </Card>

  <Card title="Automated Syncing" icon="rotate">
    Fivetran handles scheduling and incremental syncs — historical data is captured on first run, then kept up to date automatically.
  </Card>
</CardGroup>

## Synced Data

Fivetran syncs the following tables from Rootly into your destination:

| Table           | Contents                                                    |
| --------------- | ----------------------------------------------------------- |
| **Incidents**   | Core incident records — title, severity, status, timestamps |
| **Cause**       | Root cause data attached to incidents                       |
| **Roles**       | User role assignments per incident                          |
| **Form Fields** | Custom form field values                                    |
| **Workflows**   | Workflow definitions and run history                        |
| **Audit**       | Audit log entries                                           |

## Before You Begin

* You need a Fivetran account with a configured destination (Snowflake, BigQuery, Redshift, etc.)
* You need Rootly admin or owner access to generate an API key

## Installation

Setup is handled entirely in Fivetran. Rootly only needs to provide an API key.

<Steps>
  <Step title="Generate a Rootly API key">
    In Rootly, go to **Organization Settings → API Keys** and create a new API key. Copy it — you'll paste it into Fivetran.
  </Step>

  <Step title="Create a Rootly connector in Fivetran">
    In Fivetran, navigate to **Connectors** and add a new connector. Search for **Rootly** and select it.

    Enter your destination schema name and paste in your Rootly API key, then click **Save & Test**.

    <Info>
      For detailed field-by-field setup instructions, see [Fivetran's Rootly setup guide](https://fivetran.com/docs/connectors/applications/rootly/setup-guide).
    </Info>
  </Step>

  <Step title="Initial sync">
    Fivetran performs a full historical sync on first run, then syncs incrementally on a schedule based on your Fivetran plan.
  </Step>
</Steps>

## Frequently Asked Questions

<AccordionGroup>
  <Accordion title="How often does Fivetran sync Rootly data?" icon="circle-question">
    Sync frequency is determined by your Fivetran plan and connector settings. Fivetran manages the schedule — there are no sync controls in Rootly.
  </Accordion>

  <Accordion title="Will historical incident data be included?" icon="circle-question">
    Yes. The initial sync captures all historical data available via the Rootly API. Subsequent syncs are incremental.
  </Accordion>

  <Accordion title="Where can I find the schema for the synced tables?" icon="circle-question">
    Fivetran maintains the full entity-relationship diagram at the [Rootly connector ERD](https://fivetran.com/connector-erd/rootly).
  </Accordion>

  <Accordion title="Do I need to do anything in Rootly after connecting?" icon="circle-question">
    No. The integration is managed entirely from Fivetran. As long as your Rootly API key remains valid, syncs will continue automatically.
  </Accordion>
</AccordionGroup>