Go to app
Academy
What's new?
Tray UAC
Developer
Connectors
Templates
Help Center
Back
Snowflake
Overview
Notes on using Snowflake
Operations (sample payloads)
Operations
Snowflake Operations
Latest version:
2.0
Changelog
Create database
Create a database.
Create schema
Create a schema.
Create stage
Create a new named internal or external stage to use for loading data from files into Snowflake tables and unloading data from tables into files.
Create table
Create a table.
Create warehouse
Creates a new virtual warehouse in the system. Creating a warehouse includes specifying its size. Initial creation of a warehouse may take some time to provision the servers, unless the warehouse is set to be created initially in a SUSPENDED state.
Custom query
Send a custom SQL query to Snowflake.
Delete database
Removes a database from the system.
Delete files from stage
Removes files that have been staged (i.e. uploaded from a local file system or unloaded from a table)
Delete rows from table
Delete rows from the target table using optional query and additional (non-target) tables.
Delete schema
Delete a schema from the current or specified database.
Delete stage
Removes the specified named internal or external stage from the current/specified schema. The status of the files in the stage depends on the stage type.
Delete table
Delete a table from the current or specified schema.
Delete warehouse
Removes the specified virtual warehouse from the system.
Insert rows in table
Updates a table by inserting one or more rows into the table.
List copy history
This operation can be used to query Snowflake data loading history along various dimensions within the last 7 days.
List databases
Lists the databases for which you have access privileges, including the dropped databases that are still within the Time Travel retention period.
List files in stage
List the files currently in a stage.
List schemas
Lists the schemas for which you have access privileges, including the dropped schemas that are still within the Time Travel retention period.
List stages
Lists the stages for which you have access privileges.
List table columns DDL
List table rows
Lists rows in one or more tables.
List tables
Lists the tables for which you have access privileges, including the dropped tables that are still within the Time Travel retention period.
List warehouses
Lists the warehouses for which you have access privileges.
Load data to table
Load data from staged files to an existing table. The files must already be staged.
Unload data from table
Unload data from a table (or query) into one or more files in a named internal stage, a named external stage or an external stage.
Update database
Modifies the properties for an existing database, including changing the name of the database and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).
Update row in table
Updates specified rows in the target table with new values.
Update schema
Modifies the properties for an existing schema, including renaming the schema or swapping it with another schema, and changing the Time Travel data retention period (if you are using Snowflake Enterprise Edition or higher).
Update stage
Modifies the properties for an existing named internal or external stage.
Update table
Modifies the properties, columns, or constraints for an existing table.
Update warehouse
Suspends or resumes a virtual warehouse, or aborts all queries (and other SQL statements) for a warehouse. Can also be used to rename or set/unset the properties for a warehouse.
Previous
Operations (sample payloads)
