- Configure the External Database Connector for Snowflake
Describes the steps required to use the Mendix External Database connector with Snowflake.
You can combine the AI capabilities offered by Mendix and Snowflake to enable the development of low-code agentic enterprise solutions. The integration works in both directions, that is, Snowflake Cortex Agents can invoke Mendix business logic, while Mendix AI agents can connect to Snowflake MCP servers.
In addition to AI-driven applications, the integration also includes the capability to build data-driven applications. That is, you can use data from Snowflake in your Mendix app with the External Database connector or the Snowflake AI Data connector, as well as ingest your Mendix data into Snowflake by using the Mendix Data Loader.
The following diagram outlines the available integration options:
For more information, refer to the sections below.
The integration between Mendix and Snowflake offers several options for building AI-driven applications.
Mendix supports the Model Context Protocol, which is an open protocol that standardizes how Large Language Models (LLMs) can autonomously connect to apps. For more information about the available options, refer to the following topics:
The Snowflake AI Data Connector is the recommended, purpose-built method of integrating Mendix with Snowflake for the purpose of developing AI-powered Mendix apps.
You can also use the External Database connector to trigger some Cortex AI functions through SQL queries. For a comparison of the functions of the connectors, refer to the sections below.
The Snowflake AI Data Connector is the recommended option for building AI-driven applications. It enables you to perform the following tasks:
The External Database connector can also be used to support AI-driven applications by allowing you to run SQL queries that call upon some Cortex AI functions, such as sentiment. For more information, see External Database Connector: Using Cortex AI functions.
The External Database connector and the Snowflake AI Data Connector can also be used to build data-driven applications. For a comparison of the functions of the connectors, refer to the sections below.
The External Database connector is the recommended option for building data-driven applications. It offers a premium developer experience where you can test connections and queries during design time by using a view of all schemas and objects to which you can connect. It makes use of the JDBC protocol and the usage of Python stored procedures in addition to Java.
The External Database connector has GA support for Snowflake from Studio Pro 10.12 (Beta versions are available from Studio Pro 10.10).
The Snowflake AI Data Connector is primarily used for AI-driven applications, but it can also be used to perform small-scale data updates. This may be useful in cases where you are already using this connector for its AI functionalities, and you would like to do a limited amount of data processing without having to install a new connector for this purpose. However, for reading or writing large amounts of data, it is recommended to use the External Database connector instead.
The Snowflake AI Data Connector requires an additional step to transform data rows received from the REST SQL API into Mendix objects. For more information, see Snowflake AI Data Connector.
The Mendix Data Loader, available from the Snowflake Marketplace, aids in ingesting Mendix data into Snowflake. The application is deployed in your Snowflake environment and interacts with the configured Mendix apps to ingest data that is exposed using an Published OData Service.
For information about using Snowflake's role-based access control in a Mendix application, see Role-based Access Control.
Describes the steps required to use the Mendix External Database connector with Snowflake.
Describes the configuration and usage of the Mendix Data Loader application from the Snowflake Marketplace.
Describes the configuration and usage of the Mendix-Snowflake AI Data Connector from the Mendix Marketplace.
Describes the configuration and usage of the Mendix-Snowflake AI Data Connector from the Mendix Marketplace.
Describes how to use the role-based access control of Snowflake in a Mendix application.
Describes the steps required to use a Snowflake-managed MCP server with a Mendix AI agent.
Describes the steps required to use a Snowflake AI agent with a Mendix-managed MCP server.
Describes the steps required to use a Snowflake-managed MCP server with a Mendix AI agent.