| title | Transform add-ons |
|---|---|
| summary | Metabase transforms come in two flavors - basic transforms for basic query-based functionality, and advanced transforms for Python workflows, transform inspector, and other functionality. |
At a glance:
- Run query-based transforms
- Schedule transform jobs.
- (Pro/Enterprise only) Configure permissions for transforms.
- Run query-based and Python transforms;
- Schedule transform jobs.
- (Pro/Enterprise only) Configure permissions for transforms.
- Writable connection: separate database connection used for write operations.
- Transform inspector.
Availability and pricing depends on your plan and hosting method.
With basic transforms, you can:
- Write and run query-based transforms (but not Python transforms).
- Schedule and run jobs.
- (Pro/Enterprise only) Configure permissions for transforms.
-
Self-hosted Metabases: Basic transform functionality is included on self-hosted Metabases by default. Just log into your Metabase, enable transforms, and you're good to go.
-
Metabase Cloud: Basic transform functionality on Metabase Cloud - Starter, Pro, or Enterprise - comes with an additional small fee per successful transform run, see Pricing.
Only people logged in with an email of a Metabase Store admins (not just Metabase instance admins) can enable basic transforms. To enable Basic transforms on Metabase Cloud, see Enable transforms.
Once basic transforms are enabled on your Metabase Cloud instance, they can't be disabled.
Advanced transforms include:
- Everything in basic transforms.
- Python transforms for more flexible data processing.
- Writable connection: separate database connection used for write operations.
- Transform inspector.
You can buy the Advanced transforms add-on for:
-
Any Metabase Cloud instance (Starter, Pro, Enterprise)
-
Self-hosted Pro or Enterprise instances.
Currently, you can't use Advanced transforms functionality on Open Source self-hosted plans.
The Advanced transforms add-on comes with an additional charge per successful transform run (compare to Basic transforms). See Pricing.
To enable Advanced transforms functionality, you need to have Basic transforms already, see Enable basic transforms.
There are two ways to enable Advanced transforms:
-
From your Metabase instance: you can navigate to a feature requiring advanced transforms (like Python transforms or transform inspector), and follow the prompts to upgrade.
To enable Advanced transforms from your Metabase instance, you need to be logged into the instance with the same email as a Metabase Store admin, because Advanced transform incur an additional charge.
-
From Metabase Store:
- Log into Metabase Store (your Metabase Store account might be different from your Metabase instance account).
- Click on Manage plan next to the instance where you'd like to add Advanced transforms.
- Under Manage Add-ons, find Advanced transforms and click Upgrade.
Once you upgrade to Advanced transforms:
- You get access to Advanced transforms features/
- All your existing query-based transforms will be charged at Advanced transforms rate.
You can downgrade from Advanced transforms to Basic transforms.
- Log into Metabase Store (your Metabase Store account might be different from your Metabase instance account).
- Click on Manage plan next to the instance with Advanced transforms.
- Under Manage Add-ons, find Advanced transforms, click three dos and select Downgrade to basic.
Once you downgrade from advanced transforms:
- Your Python transforms will no longer run and will be removed.
- Transforms and other write features will stop using the writable connection (if you had one configured.)
Unless you're on an Enterprise plan, transforms - either basic (on Metabase Cloud) or advanced - are billed based on the number of successful runs. See Jobs and runs for more on transform runs, and Pricing for up-to-date information on pricing.
When you upgrade from basic to advanced transforms, all your transforms will be billed at advanced transforms rate.
If you're on an Enterprise plan and have questions about billing, contact us.