.svg)
.svg)
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:| 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.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.
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.
Frequently Asked Questions
How often does Fivetran sync Rootly data?
How often does Fivetran sync Rootly data?
Sync frequency is determined by your Fivetran plan and connector settings. Fivetran manages the schedule — there are no sync controls in Rootly.
Will historical incident data be included?
Will historical incident data be included?
Yes. The initial sync captures all historical data available via the Rootly API. Subsequent syncs are incremental.
Where can I find the schema for the synced tables?
Where can I find the schema for the synced tables?
Fivetran maintains the full entity-relationship diagram at the Rootly connector ERD.
Do I need to do anything in Rootly after connecting?
Do I need to do anything in Rootly after connecting?
No. The integration is managed entirely from Fivetran. As long as your Rootly API key remains valid, syncs will continue automatically.