Transformations Pricing
Fivetran charges for data transformation usage for Quickstart data models and Fivetran-hosted Transformations for dbt Core. We charge for usage based on the total number of successful monthly model runs. Models are SQL statements that produce a materialized table or data view. This includes all upstream and intermediate models before the final output model. Transformations often consist of multiple interdependent models working together at various stages of the pipeline to produce the final dataset.
We count only successful model runs toward your usage. Let’s consider the following scenarios:
- Successful job: You have a transformation job that was completed successfully. All the model runs that were a part of that job were successful and count toward your usage.
- Partially completed job: A job was partially completed. Any successful model runs within that job count towards your usage.
- Repeated job runs: You have jobs that run multiple times a month. Each time the models run successfully as part of the jobs, they count towards your usage.
- Failed job runs: You have a job that fails, and none of the job’s models run successfully. This does not count toward your transformation usage.
NOTE: We don’t charge for usage related to the Fivetran Platform Quickstart data model. We also don’t charge for third-party orchestrations such as dbt Cloud Integration and Coalesce.
Transformations pricing tiers
Transformations pricing is usage-based. Each month, the first 5,000 successful model runs are free. Any usage beyond the 5,000 successful model runs mark is paid, and the higher the usage, the lower the cost per successful model run.
See transformations pricing tiers below:
| Total monthly model runs | List rate per model run |
|---|---|
| 0 - 5,000 | Free usage |
| 5,000 - 30,000 | $0.01 |
| 30,000 - 100,000 | $0.007 |
| 100,000+ | $0.002 |
Additionally, consider the image below that exemplifies using 35,000 model runs a month:
Free usage
The following transformations usage is free:
- Any usage related to the Fivetran Platform Quickstart data model.
- Third-party orchestrations, such as dbt Cloud Integration and Coalesce.
- The first 5,000 successful model runs each month. Additionally, only successful model runs count toward your usage.
Free plan
Fivetran’s Free plan supports Quickstart data models and dbt Core Transformations. However, your usage is limited to 5,000 successful monthly model runs. If you exceed the limit, you can either optimize your usage or upgrade to a paid plan. See Transformations FAQs for more details.
Monitoring transformation usage and costs
Monitor your transformation usage and costs in your Fivetran dashboard or by using the Fivetran Platform Connector.
See our Transformations Usage Optimization documentation for best practices for controlling costs.
NOTE: During the account free trial period, we collect one to seven days’ worth of transformations usage data to provide a usage and cost estimate. This is the most reliable way of determining your transformations usage and pricing. See our Transformations Usage Estimate documentation for more details.
Fivetran dashboard
You can monitor your transformation usage in the Fivetran dashboard. Go to Billing & Usage > Transformations to see your total usage.
The Monthly overview section displays how much of your free monthly usage you have consumed so far in the month. It also displays the number of paid model runs and the associated costs (if any).
You can break down usage by Month, Destination, Transformation, and Run type (Metered runs and Free runs).
Metered runs
Metered runs include all your usage on a paid plan. It includes the 5,000 free model runs as well as any paid usage you may have.
Free runs
Free runs include the free 5,000 model runs you receive each month.
Fivetran Platform Connector
The Fivetran Platform Connector syncs your transformation usage data into your destination, allowing you to analyze it just like any other data. The TRANSFORMATION_RUNS table provides the total number of successful transformation model runs during a specific month. The model run count resets to zero at the beginning of each month.
For more information, see our Fivetran Platform Connector documentation.