Dynamic Tables Dynamic Tables 20 Questions Ask question Search Order By: ActiveTagClear Filter 0 Votes 1 Ans We use Stored Procedures to refresh our datamart. Should we replace them with dynamic tables? 1.35K viewsDaniel Steinhold Answered question May 28, 2024Dynamic Tables 0 Votes 1 Ans Can we say Dynamic tables are the replacement for Stored Procedures? 1.00K viewsDaniel Steinhold Answered question May 28, 2024Dynamic Tables 0 Votes 1 Ans Is there a plan to allow Dynamic Tables to run on a schedule? 1.20K viewsDaniel Steinhold Answered question May 28, 2024Dynamic Tables 0 Votes 1 Ans Are dynamic tables similar to the classic materialized view? 956 viewsDaniel Steinhold Answered question May 28, 2024Dynamic Tables 0 Votes 1 Ans Do dynamic tables need a primary/logical key defined in the underlying tables? 1.35K viewsDaniel Steinhold Answered question May 28, 2024Dynamic Tables 0 Votes 1 Ans How many cluster keys can reside on a Snowflake table? 2.25K viewsDaniel Steinhold Changed status to publish March 24, 2024Dynamic Tables 0 Votes 1 Ans What are some future advancements or considerations for the evolution of dynamic tables? 908 viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans How does Snowflake handle schema changes in the source tables used by dynamic tables? 1.72K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans Can dynamic tables leverage features like clustering keys for performance improvements? 1.64K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans Are there limitations to the types of SQL statements supported within dynamic tables? 1.08K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans How can I optimize the cost-efficiency of dynamic table refreshes? 987 viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans What are the considerations for sharing dynamic tables with other Snowflake accounts? 1.03K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans How can I troubleshoot and resolve errors encountered during dynamic table refreshes? 1.48K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans What are some best practices for managing dependencies between dynamic tables? 1.05K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans How can I monitor the refresh history and identify potential issues with dynamic tables? 1.53K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans What are the different states a dynamic table can be in (e.g., active, suspended)? 1.23K viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans In what scenarios are dynamic tables a good choice for data transformation pipelines? 962 viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans What the components of a dynamic table definition, including the SQL statement and refresh schedule? 904 viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans How do dynamic tables differ from traditional tables with manual data manipulation (DML)? 907 viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables 0 Votes 1 Ans What are dynamic tables in Snowflake, and how do they simplify data engineering workflows? 858 viewsDaniel Steinhold Changed status to publish March 15, 2024Dynamic Tables