The add-in uses the Snowflake API to enable bidirectional SQL access.

Discovering Schemas

The CData Excel Add-In for Snowflake automatically retrieves the structure of your data from Snowflake, including warehouses, databases, and schemas. Specifying a database or schema is optional, but doing so limits the available tables and views to only those within the selected database or schema.

Stored Procedures

Stored Procedures are function-like interfaces to Snowflake. They are used for OAuth authentication.