Snowflake REST SQL Connector

Content Type: Module
Categories: Snowflake,Connectors

Overview

The Snowflake REST SQL connector provides a way to first setup key-pair authentication with an RSA key pair according to PKCS #8 standard and then execute SQL statements on Snowflake via a REST call from within your Mendix application. These statements allow you to

- Read data from Snowflake

- Write data to Snowflake

- Trigger Snowflake Cortex ML functions (see https://docs.snowflake.com/en/guides-overview-ml-functions)

- Use Snowflake Cortex LLM functions (see https://docs.snowflake.com/en/user-guide/snowflake-cortex/llm-functions).

 

The connector currently supports:

- authentication with a RSA key pair according to PKCS #8 standard

- execution of single SQL statements

- synchronous execution of calls

Documentation

Please see the documentation on Mendix Docs.

 

Releases

Version: 1.1.0
Framework Version: 9.18.0
Release Notes: - Association between ConnectionDetails and Account entity added - Small bug fixes
Version: 1.0.0
Framework Version: 9.18.0
Release Notes: - Pages for management of connection details including set up of key-pair authentication - Two operations to execute statements and transform responses to Mendix objects