dynamic-tables-apply-recommendations
Apply Snowflake-emitted recommendations to a specific dynamic table. Triggers: apply DT recommendations, apply recommendations to dynamic table, look at recommendations for, RECOMMENDATIONS column, AUTO_RESOLVED_TO_FULL_REFRESH, QUALIFY_RANK_NOT_TOP_LEVEL, TOP_LEVEL_AGGREGATE_NOT_TOP_LEVEL, QUALIFY_RANK_KEYS_NOT_PERSISTED, TOP_LEVEL_AGGREGATE_EXPRESSIONS_NOT_PERSISTED, EXPENSIVE_ORDER_DEPENDENT_WINDOW_FUNCTION, NON_MONOTONIC_GROUPING_KEY, HIGH_BASE_TABLE_CHANGES, CHANGED_BASE_TABLES_UNDER_JOIN, WAREHOUSE_TOO_SMALL, ICEBERG_BASE_TABLE_V2_TO_V3.
Pinned to revision 05cff3d0ec12, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/dynamic-tables-apply-recommendations/SKILL.md
- skills/dynamic-tables-apply-recommendations/references/codes/AUTO_RESOLVED_TO_FULL_REFRESH.md
- skills/dynamic-tables-apply-recommendations/references/codes/CHANGED_BASE_TABLES_UNDER_JOIN.md
- skills/dynamic-tables-apply-recommendations/references/codes/EXPENSIVE_ORDER_DEPENDENT_WINDOW_FUNCTION.md
- skills/dynamic-tables-apply-recommendations/references/codes/HIGH_BASE_TABLE_CHANGES.md
- skills/dynamic-tables-apply-recommendations/references/codes/ICEBERG_BASE_TABLE_V2_TO_V3.md
- skills/dynamic-tables-apply-recommendations/references/codes/NON_MONOTONIC_GROUPING_KEY.md
- skills/dynamic-tables-apply-recommendations/references/codes/QUALIFY_RANK_KEYS_NOT_PERSISTED.md
- skills/dynamic-tables-apply-recommendations/references/codes/QUALIFY_RANK_NOT_TOP_LEVEL.md
- skills/dynamic-tables-apply-recommendations/references/codes/TOP_LEVEL_AGGREGATE_EXPRESSIONS_NOT_PERSISTED.md
- skills/dynamic-tables-apply-recommendations/references/codes/TOP_LEVEL_AGGREGATE_NOT_TOP_LEVEL.md
- skills/dynamic-tables-apply-recommendations/references/codes/WAREHOUSE_TOO_SMALL.md
- skills/dynamic-tables-apply-recommendations/references/frozen-where-guidance.md
- skills/dynamic-tables-apply-recommendations/references/primary-key-rely.md
- skills/dynamic-tables-apply-recommendations/references/recommendation-codes.md
Every link opens the file at its source, pinned to the revision this page describes.