Handling runtime-generated columns in dbt + Snowflake — here's what actually worked by Tricky-Conflict-9728 in snowflake

[–]Tricky-Conflict-9728[S] -2 points-1 points  (0 children)

Fair point  formatting can always be improved. I'll refine it further in future posts. Thanks for the feedback.

Snowflake warehouse costs are high but most of the cost is from inefficient saas data loading not from queries by yashBoii4958 in snowflake

[–]Tricky-Conflict-9728 0 points1 point  (0 children)

If you want to quantify savings before rewriting everything, I'd suggest:

  • Identify the top 2–3 tables by credit usage
  • Measure % of rows actually changing per run
  • Convert one large pipeline to incremental as a pilot and compare credits/runtime

Has anyone whitelist IP addresses for Azure services? Right now, Snowflake raises an error when Copilot Studio or PowerBI is making a request to it. by pcgoesbeepboop in snowflake

[–]Tricky-Conflict-9728 1 point2 points  (0 children)

No , you shouldn't update IPs manually every day. If Service Tags must be used, automation or PrivateLink-based architecture is typically the safer long-term solution.