Overview

The Snowflake REST SQL connector makes it possible to

• Setup key-pair authentication with an RSA key pair according to PKCS #8 standard
• 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).
  • Use Snowflake Cortex Analyst (see Cortex Analyst | Snowflake Documentation)

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

- use of Snowflake Cortex Analyst  

Documentation

Please see the documentation on Mendix Docs.

Please note that the dependency on GenAI Commons is on GenAI commons version 3.x, not higher!