Interactive Table
@coalesce/snowflake/interactive-table 
Overview
Interactive table deliver low-latency query performance for high-concurrency, interactive workloads.
Installation
- Copy the Package ID:
@coalesce/snowflake/interactive-table - In Coalesce, open the Workspace where you wish to install the package.
- Go to the Build Setting of the Workspace, tab Packages, and click the Install button on the top right of the page.
- Paste the Package ID, and proceed with the installation process.
Description
Interactive Table Package
Package Includes
Interactive Table
The Coalesce Interactive Table UDN allows you to build and deploy Snowflake Interactive Table, which are optimized for low-latency, high-performance analytical queries.
Interactive Table refresh automatically based on a SQL definition and maintain optimized storage for low-latency, high-concurrency queries. This makes them ideal for powering live dashboards, APIs, and sub-second analytical loads—while reducing operational complexity and maintaining strong price-performance.
NOTE: Interactive Table can be only created at the end of a data pipeline. It cannot be used as a source for other table.
Interactive Table Node Configuration
Node properties
| Property | Description |
|---|---|
| Storage Location | (Required) Storage Location where the Interactive Table will be created |
| Node Type | (Required) Name of template used to create node objects |
| Description | A description of the node's purpose |
| Deploy Enabled | If TRUE the node will be deployed/redeployed when changes are detected If FALSE the node will not be deployed or will be dropped during redeployment |
General Options
| Property | Description |
|---|---|
| Multi Source | Toggle: True/False Implementation of SQL UNIONs True: Combine multiple sources in a single node True Options: - UNION: Combines with duplicate elimination - UNION ALL: Combines without duplicate elimination |
| Enable tests | Toggle: True/False Determines if tests are enabled |
| Distinct | Toggle: True/False True: Group by All is invisible. DISTINCT data is chosen for processing False: Group by All is visible |
| Group by All | Toggle: True/False True: DISTINCT is invisible. Data is grouped by all columns for processing False: DISTINCT is visible |
| Cluster key | True/False toggle for clustering: - True: Specify clustering column and optional expressions - False: No clustering |
| Allow Expressions Cluster Key | When cluster key is set to true. Allows to add an expression to the specified cluster key |
| Auto Refresh | Toggle: True/False True Dynamic Interactive Table options visible. -False: Creates Static Interactive table. |
Dynamic Interactive Table Options
| Option | Description |
|---|---|
| Lag Specification | Time Value: Frequency of the refresh - Time Period: Seconds/Minutes/Hours/Days |
| Warehouse | (Required) Name of warehouse used to refresh the Interactive Table |
Interactive Table Deployment
Interactive Table Initial Deployment Parameters
The Interactive Table includes an environment parameter that allows you to specify a different warehouse to refresh a Interactive Table in different environments.
The parameter name is targetInteractiveTableWarehouse and the default value is DEV ENVIRONMENT.
When set to DEV ENVIRONMENT, the value entered in the Interactive Table Options config "Warehouse on which to execute Interactive Table" will be used when creating the Interactive Table.
{
"targetInteractiveTableWarehouse": "DEV ENVIRONMENT"
}
When set to any value other than DEV ENVIRONMENT the node will attempt to create the Interactive Table using a Snowflake warehouse with the specified value.
For example, the Interactive Table will refresh using a warehouse named compute_wh.
{
"targetInteractiveTableWarehouse": "compute_wh"
}
📘 Deployment of nodes without adding parameters
This results in a WARNING stage getting executed insisting to execute the node after adding parameters
Interactive Table Initial Deployment
When deployed for the first time into an environment the Interactive Table node will execute the following stage:
| Stage | Description |
|---|---|
| **Create Interactive Table | This stage will execute a CREATE OR REPLACE statement and create a Interactive Table in the target environment. |
Interactive Table Redeployment
After initial deployment, subsequent deployments may recreate the Interactive Table.
Recreating the Interactive Table
The following config changes trigger REPLACE statements:
- Warehouse name
- Auto refresh setting
- Lag specification
This executes a stage:
| Stage | Description |
|---|---|
| CREATE or REPLACE Interactive Table | Executes CREATE or REPLACE to modify parameters |
Also if the location of the node, node name, column level description, and table level description results in an CREATE or REPLACE statement, whereas table name change result in a ALTER statement.
Redeployment with no changes
If the nodes are redeployed with no changes compared to previous deployment,then no stages are executed
Interactive Table Undeployment
A table will be dropped if all of these are true:
- The Interactive Node is deleted from a space.
- The space is committed to Git.
- The space committed to Git is deployed to a higher level environment.
| Stage | Description |
|---|---|
| Drop Interactive Table | Removes table from target environment |
Code
Interactive Table Code
Versions
Available versions of the package.
| Version # | Release Date | Notes |
|---|---|---|
| 1.0.0 | December 08, 2025 | Interactive table first release. |