Overview

The Snowflake AI Data Connector (formerly known as 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 https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-analyst)
  • Use Snowflake Cortex Search (see https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-search/cortex-search-overview)

The connector supports:

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

- execution of single SQL statements

- synchronous execution of calls

- use of Snowflake Cortex Analyst

- use of Snowflake Cortex Search

Documentation

Please see the documentation on Mendix Docs.

You can also take a look at the Snowflake Showcase app which also provides some additional information on how to setup the authentication.