Support Snowflake as a Runtime Database Across All Mendix Deployment Environments - Mendix Forum

Support Snowflake as a Runtime Database Across All Mendix Deployment Environments

15

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:

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:

  1. Mendix Cloud

  2. Mendix on Kubernetes / Private Cloud

  3. On-premises deployments

  4. Self-hosted Docker or virtual machine environments

  5. Other supported hosting environments

Requested Capabilities

Expected Benefits

Supporting Snowflake as a runtime database would enable organizations to:

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.

asked
2 answers

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.

Created

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

Created