Fivetran

​

Use Cases

• Build custom dashboards and visualizations in your BI tool of choice
• Analyze incident trends over time and identify patterns
• Combine Rootly incident data with other business metrics
• Create executive reports on MTTR, incident frequency, and team performance
• Perform advanced analytics and forecasting on incident data

​

Synced Data Tables

• Audit - Audit logs and history
• Cause - Incident root causes
• Form fields - Custom form field data
• Incidents - Core incident information
• Roles - User roles and assignments
• Workflows - Workflow definitions and runs

​

Requirements

• Fivetran account with a configured destination (data warehouse)
• Rootly admin or owner access (required to generate API keys)

​

Installation

1. Ensure you have a destination configured in Fivetran (e.g., Snowflake, BigQuery, Redshift)
2. Generate a Rootly API key from Organization Settings > API Keys
3. In Fivetran, create a new Rootly connector
4. Enter your destination schema name and Rootly API key
5. Click Save & Test to begin syncing

​

Additional Resources

• Fivetran’s Rootly setup guide - Detailed configuration instructions
• Fivetran’s Rootly API configuration - API setup details
• Rootly connector ERD - Database schema and relationships

​

Notes

• Sync frequency is managed by Fivetran and depends on your Fivetran plan
• Historical data will be synced during the initial connector setup
• Ensure your data warehouse has sufficient storage for the synced data