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

Installable Elements              (No items selected)



Base Elements

These elements are required for the templates below to work

  • Remote Site Settings for Snowflake API calls

Accounts

API calls for account management

  • API Call to list Snowflake accounts

  • API call to create a Snowflake account

  • API call to delete a Snowflake account

Databases

API calls for database management

  • API Call to list Snowflake databases

  • API call to create a Snowflake database

  • API call to fetch the details of a Snowflake database

  • API call to delete a Snowflake database

Schemas

API calls for schema management

  • API call to list schemas from a Snowflake database

  • API call to create a schema in a Snowflake database

  • API call to featch the details of a schema in a Snowflake database

  • API call to delete a schema from a Snowflake database

Tables

API calls for table management

  • API call to list tables from a Snowflake schema

  • API call to create a table in a Snowflake schema

  • API call to featch the details of a table in a Snowflake schema

  • API call to delete a table from a Snowflake schema

SQL

Running SQL statements

  • Submit a request to execute SQL statements

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.