capabilities.work

Create, Verify, and Refresh a Dynamic Table

A 3-step recipe with Snowflake. We can help you get access.

Recipe · 3 steps

Create, Verify, and Refresh a Dynamic Table

with Snowflake

Create a dynamic table, fetch it to confirm, then refresh it manually.

  1. Create the dynamic table from its query, warehouse, and target lag.
  2. Describe the dynamic table to confirm creation and read its scheduling state.
  3. Trigger a manual refresh of the dynamic table.
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 and dynamic table.
  • schemaName: Schema that holds the dynamic table.
  • tableName: Name of the dynamic table to create.
  • warehouse: Warehouse used to refresh the dynamic table.
  • query: The query that the dynamic table materializes.
  • targetLag: The target lag object that controls refresh frequency.
For your developer

Arazzo workflow snowflake:create-and-refresh-dynamic-table, 3 operations: createDynamicTable → fetchDynamicTable → refreshDynamicTable. Specs on APIs.io.

More recipes with Snowflake

Cancel a Running SQL StatementClone a Database and VerifyCreate and Execute an AlertCreate, Resume, and Execute a TaskCreate, Verify, and Refresh a PipeCreate and Verify WarehouseCreate Database, Verify, and Add SchemaCreate Role and Grant PrivilegesCreate Schema and TableCreate Stage, Verify, and List Files