Skip to main content

​
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.

Warehouse Sync

Pull Rootly incidents, workflows, roles, and more into Snowflake, BigQuery, Redshift, or any Fivetran-supported destination.

Custom Dashboards

Build tailored visualizations and executive reports in your BI tool of choice — beyond what Rootly’s built-in analytics provide.

Cross-Data Analysis

Join Rootly incident data with other business metrics for deeper trend analysis and forecasting.

Automated Syncing

Fivetran handles scheduling and incremental syncs — historical data is captured on first run, then kept up to date automatically.

​
Synced Data

Fivetran syncs the following tables from Rootly into your destination:

​
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.
1

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.
2

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.
For detailed field-by-field setup instructions, see Fivetran’s Rootly setup guide.
3

Initial sync

Fivetran performs a full historical sync on first run, then syncs incrementally on a schedule based on your Fivetran plan.

​
Frequently Asked Questions

Sync frequency is determined by your Fivetran plan and connector settings. Fivetran manages the schedule — there are no sync controls in Rootly.
Yes. The initial sync captures all historical data available via the Rootly API. Subsequent syncs are incremental.
Fivetran maintains the full entity-relationship diagram at the Rootly connector ERD.
No. The integration is managed entirely from Fivetran. As long as your Rootly API key remains valid, syncs will continue automatically.