Feature Request: Snowflake Runtime Database Support Across All Mendix Deployment Environments
We would like to request official support for Snowflake as a Mendix runtime database across all supported deployment environments.
Current Challenges
Currently, Mendix requires a supported database for runtime persistence, while Snowflake is accessible through external data integration mechanisms rather than as a runtime database.
For organizations already using Snowflake as their primary enterprise data platform, this creates several challenges:
Maintaining separate databases for Mendix runtime persistence and Snowflake data storage.
Additional complexity in data synchronization and management.
Increased infrastructure and operational costs.
Difficulty establishing Snowflake as a centralized data platform.
Existing integrations, such as the External Database Connector and Snowflake Mendix Data Loader, enable data connectivity but do not allow Snowflake to serve as the Mendix runtime database.
Proposed Solution
We propose adding Snowflake as an officially supported runtime database option across all applicable Mendix deployment environments, including:
Mendix Cloud
Mendix on Kubernetes / Private Cloud
On-premises deployments
Self-hosted Docker or virtual machine environments
Other supported hosting environments
Requested Capabilities
Snowflake support for Mendix runtime persistence.
Full CRUD support (Create, Read, Update, Delete) for Mendix entities.
Compatibility with domain models, associations, and microflows.
Support for runtime transactions, data consistency, and persistence operations.
Database configuration and deployment support through Mendix Studio Pro and relevant deployment tools.
Official documentation and production support.
Expected Benefits
Supporting Snowflake as a runtime database would enable organizations to:
Simplify application and data architectures.
Reduce data duplication and synchronization overhead.
Consolidate application data within existing Snowflake environments.
Minimize infrastructure and maintenance complexity.
Improve integration between Mendix applications and enterprise data platforms.
We recognize that Snowflake differs architecturally from traditional transactional databases and that additional compatibility considerations may be necessary.
Nevertheless, we believe this capability would provide significant value to organizations using Snowflake as their centralized data platform.
We would appreciate consideration of this feature in a future Mendix release, with support across deployment environments rather than being limited to a specific hosting configuration.
My colleague already shared my earlier blog post, so here's where things are now.
You can run Mendix apps inside your own Snowflake account today. The catch is that the runtime database is Snowflake Postgres, not regular Snowflake tables. Mendix needs a transactional database: lots of small writes, row locking, quick single-row lookups. Snowflake warehouses are built for analytics and don't handle that kind of load well. Snowflake Postgres does, and Snowflake manages it inside your account, so you're not running a separate database somewhere else.
The project is open source: https://github.com/mendixlabs/mendix-for-snowflake
The Mendix runtime runs as a container in Snowpark Container Services. App data goes to Snowflake Postgres, and files go to Snowflake stages. Domain models, associations, microflows and transactions all work the way you'd expect. Users log in with their Snowflake identity. Apps can query your Snowflake data as the logged-in user, so Snowflake's own permissions still apply and you don't need to copy data into the app. There's also an admin UI for deploying, rolling back, suspending and monitoring apps. It's packaged as a Snowflake Native App, and I hope we'll have it on the Snowflake Marketplace soon.
That covers a good part of what the request asks for. Your app data and analytics data live in the same Snowflake account, there's less syncing, and there's no extra infrastructure to run.
One limit to be clear about: this only works for Mendix running on Snowflake itself. It doesn't add Snowflake as a database option for Mendix Cloud, Kubernetes, or on-prem. For those, the External Database Connector and the Snowflake Mendix Data Loader are still the way to get at Snowflake data.
The README and how-to guide in the repo cover setup and known limitations. If you try it, feedback and GitHub issues are very welcome.
Next to this, we also have the Mendix Event Broker Change Data Capture feature that will be able to write any Mendix data changes to an Iceberg table, this can of course be a Snowflake Iceberg table as well. This let's you sync your Mendix data directly into Snowflake.
Are customers asking for this directly or is this a need in your organization right now? Feel free to reach out over email to talk more: robert.van.thof@siemens.com.
Hi Jeong,
We're aware of this request, but it's quite complext to have this rolled out with all features we currently provide with our supported cloud solutions, where network latency is one of the main pain points, due to heavy communication between Mendix app and it's database.
You also can take a look at deploying a Mendix app in Snowflake’s Snowpark Container Services, where the Snowflake database is used as primary database for the Mendix app, see https://medium.com/@robert.van.thof/mendix-on-snowflake-from-proof-of-concept-to-a-small-platform-052e53e9bfc7 .
Thanx for sharing this feature request, so we can take this into account.
Best Regards,
Emiel Paasschens,
teamlead Tech Alliance Deveopment team