Create Table and Insert Rows via SQL
A 2-step recipe with Snowflake. We can help you get access.
Recipe · 2 steps
Create Table and Insert Rows via SQL
with Snowflake
Create a table with a DDL statement, then insert rows with a second statement.
- Submit the CREATE TABLE DDL statement. A 200 indicates the table was created successfully.
- Submit the INSERT statement against the newly created table. A 200 returns execution stats including the number of rows inserted.
What you'll need to have ready
- authToken: Bearer token (KEYPAIR_JWT, OAUTH, or programmatic access token).
- tokenType: Value for the X-Snowflake-Authorization-Token-Type header.
- createStatement: The CREATE TABLE DDL statement.
- insertStatement: The INSERT statement to load rows into the new table.
- warehouse: Warehouse to use when executing the statements.
- database: Database in which the statements should be executed.
- schema: Schema in which the statements should be executed.
For your developer
Arazzo workflow snowflake:create-table-and-insert-via-sql, 2 operations: submitStatement → submitStatement. Specs on APIs.io.