Snowflake

Snowflake is a cloud-based data warehousing platform designed to store, process, and analyze large volumes of structured and semi-structured data. Its architecture separates compute from storage, allowing workloads to scale independently and making it suitable for analytics, data engineering, and data-sharing use cases. Snowflake exposes multiple programmatic interfaces rather than a single “Snowflake API.” These include the REST API, Snowflake SQL API, and various language-specific connectors (such as Python, Java, and Node.js).

The Snowflake SQL API allows applications to send SQL statements over HTTPS, retrieve query results, manage sessions, and monitor query status. This is useful when a direct database connection is not feasible. Snowflake’s REST endpoints also support tasks like managing authentication with OAuth, handling file uploads to internal stages, and interacting with Snowpipe for continuous data ingestion. Combined with connectors and drivers, these APIs enable applications to integrate data loading, query execution, and warehouse operations into automated workflows and external systems.

Documentation URL: https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api

Select All

Installable Elements

Select All

Base Elements

These elements are required for the templates below to work

Snowflake API Remote Site Settings
Remote Site Settings for Snowflake API calls

Select All

Accounts

API calls for account management

Snowflake - List Accounts
API Call to list Snowflake accounts

In order to install this in your org, you need to access the library from the Declarative Webhooks app in your Salesforce org, Declarative Webhooks Library tab.