Snowflake Modules

1 Introduction

Mendix has several options available for users who want to integrate their app with Snowflake in order to create data-driven enterprise applications.

2 Snowflake Integration Options  

Mendix provides real-time interaction with Snowflake through the External Database connector or the REST SQL connector. Both of these connectors enable you to perform the following tasks:

• Read, write, and use data from Snowflake in your application.
• Execute Java stored procedures.
• Leverage Cortex Machine Learning and Cortex Large Language Model functions.

For a comparison of the functions of both connectors, refer to the sections below.

2.1 External Database Connector

The External Database connector is the recommended option that you can use to integrate your Mendix app with Snowflake. 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 only supports system-level authentication. That is, it authenticates in Snowflake by using the username and password of a single Snowflake user. Because of that, the connector does not support role-based access control (RBAC) per end user.

The Snowflake support for the External Database connector is currently in a public Beta version. It is available only for Mendix 10.

2.2 REST SQL Connector

The REST SQL connector, available from the Mendix Marketplace, supports the 9.24 LTS version of Mendix. It offers key-pair authentication with a private key file according to PKCS #8 standard.

With the REST SQL connector, authentication can be done either on system or on end-user level, and the connector supports role-based access control (RBAC) per end user as well.

The REST SQL connector requires an additional step to transform data rows received from the REST SQL API into Mendix objects. For more information, see Snowflake REST SQL Connector.

2.3 Mendix Data Loader

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.

2.4 Role Base Access Control (RBAC)

For information about using Snowflake’s role-based access control in a Mendix application, see Role-based Access Control.

3 Documents in This Category