Create Database, Verify, and Add Schema
A 3-step recipe with Snowflake. We can help you get access.
Recipe · 3 steps
Create Database, Verify, and Add Schema
with Snowflake
Create a database, fetch it to confirm, then create a schema within it.
- Create the database using errorIfExists create mode.
- Describe the database by name to confirm it exists before adding a schema.
- Create the schema inside the confirmed database.
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.
- comment: Optional comment applied to the created resources.
For your developer
Arazzo workflow snowflake:create-database-and-schema, 3 operations: createDatabase → fetchDatabase → createSchema. Specs on APIs.io.