Provision Database, Schema, and Table
A 3-step recipe with Snowflake. We can help you get access.
Recipe · 3 steps
Provision Database, Schema, and Table
with Snowflake
Create a database, a schema within it, and a table within the schema.
- Create the database using errorIfExists create mode.
- Create the schema inside the newly created database.
- Create the table inside the newly created database and schema.
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 database to create.
- schemaName: Name of the schema to create within the database.
- tableName: Name of the table to create within the schema.
- columns: Column definitions for the new table (name and datatype).
- comment: Optional comment applied to the created resources.
For your developer
Arazzo workflow snowflake:provision-database-schema-table, 3 operations: createDatabase → createSchema → createTable. Specs on APIs.io.