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 supports:

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

- execution of single SQL statements

- synchronous execution of calls

Documentation

Please see the documentation on Mendix Docs.