Create a Table and a Change Stream On It
A 3-step recipe with Snowflake. We can help you get access.
Recipe · 3 steps
Create a Table and a Change Stream On It
with Snowflake
Create a table, create a stream tracking it, then fetch the stream to confirm.
- Create the source table that the stream will track.
- Create the stream that tracks changes to the source table.
- Describe the stream to confirm it was created and read back its source.
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: Database that holds the schema, table, and stream.
- schemaName: Schema that holds the table and stream.
- tableName: Name of the source table to create and track.
- columns: Column definitions for the source table (name and datatype).
- streamName: Name of the stream to create on the table.
- comment: Optional comment applied to the stream.
For your developer
Arazzo workflow snowflake:create-stream-on-table, 3 operations: createTable → createStream → fetchStream. Specs on APIs.io.