Create Schema and Table
A 3-step recipe with Snowflake. We can help you get access.
Recipe · 3 steps
Create Schema and Table
with Snowflake
Create a schema, create a table within it, then fetch the table to confirm.
- Create the schema in the existing database.
- Create the table inside the newly created schema.
- Describe the table to read back its persisted definition.
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.
- databaseName: Name of the existing database that holds the schema.
- schemaName: Name of the schema to create.
- tableName: Name of the table to create within the schema.
- columns: Column definitions for the new table (name and datatype).
For your developer
Arazzo workflow snowflake:create-schema-and-table, 3 operations: createSchema → createTable → fetchTable. Specs on APIs.io.