Hi, i create a dynamic table and have task that validates data on tables (standard tables) that are used in the dynamic table. The thing is when i finish the validations i need, i put an ALTER DYNAMIC TABLE IF EXISTS xxx REFRESH; inside the task, and when the task is executed the refresh is not starting. If i execute manually the command it works but is like it doesn't when is inside the task, is this a limitation right now??
I could not find anywhere in documentation, but is there any optimisation in create-replace of a dynamic table. Does it have any way to know that may be some partial data is already there. For example when we introduce a new column, it is highly likely that no other data was changed but does dynamic table consider this when it refreshes on create-replace.
Thanks for your question! Create or replace for Dynamic Tables works just like a create or replace for any ordinary table, so the dynamic table would indeed get rebuilt.
dynamic tables can be monitor through snowsight->activity->dynamic table I need to know which snowflake account usage table it is using to display dynamic tables details in snowsight? I need to get all the refresh history of all the tables, so how to get this details?
Check this page out on monitoring dynamic table refresh history: docs.snowflake.com/en/user-guide/dynamic-tables-tasks-monitor#label-dynamic-tables-monitoring-sql
DT are very useful to simplify pipelines and object management, support, monitoring, documentation and support.
Totally agree!
Hi, i create a dynamic table and have task that validates data on tables (standard tables) that are used in the dynamic table. The thing is when i finish the validations i need, i put an ALTER DYNAMIC TABLE IF EXISTS xxx REFRESH; inside the task, and when the task is executed the refresh is not starting. If i execute manually the command it works but is like it doesn't when is inside the task, is this a limitation right now??
Can I create the DT on top of external table ! looks it won't allow, is there any work around if in case I need to use external table ?
I could not find anywhere in documentation, but is there any optimisation in create-replace of a dynamic table. Does it have any way to know that may be some partial data is already there.
For example when we introduce a new column, it is highly likely that no other data was changed but does dynamic table consider this when it refreshes on create-replace.
Thanks for your question! Create or replace for Dynamic Tables works just like a create or replace for any ordinary table, so the dynamic table would indeed get rebuilt.
where you define call start_data_gen(); and call send_alert_email(); function ?
Pretty awesome
Glad you enjoyed!
Hi, can we write dynamic table definition using python instead of SQL?
dynamic tables can be monitor through snowsight->activity->dynamic table
I need to know which snowflake account usage table it is using to display dynamic tables details in snowsight?
I need to get all the refresh history of all the tables, so how to get this details?
Check this page out on monitoring dynamic table refresh history: docs.snowflake.com/en/user-guide/dynamic-tables-tasks-monitor#label-dynamic-tables-monitoring-sql
Also, table_type = base table, is_dynamic= true is how a Dynamic Table shows up in account usage
The demo example is pretty complex and the presentor should have chosen a simple example to explain things.
Thank you for your feedback!
we can use non dynamic tables in the dynamic sql?
Yes
where you define call start_data_gen(); and call send_alert_email(); function ?
THE SAME ISSUE!!!