SELECTSELECT

Latest

All Posts

Alerts & Notifications in Snowflake (Updated for 2024)
By Tomáš SobotíkDec 31, 20239 min read

Alerts & Notifications in Snowflake (Updated for 2024)

In this post Tomáš of Tietoevry does a deep dive into Snowflake native alerting and notification features.

The definitive guide to using Snowflake Tasks
By Tomáš SobotíkNov 19, 202310 min read

The definitive guide to using Snowflake Tasks

A deep dive into all things Snowflake Tasks. Tomas covers setting up Tasks with dependencies, choosing a compute model and operational considerations when managing Tasks.

A deep dive into Snowflake storage costs
By Andrey BystrovOct 31, 202315 min read

A deep dive into Snowflake storage costs

Andrey unpacks Snowflake proprietary storage system and covers key concepts such at table versioning, failsafe, time travel and billing.

Proven methods for optimizing your dbt project - dbt Coalesce 2023
By Ian Whitestone & Niall WoodwardOct 29, 20232 min read

Proven methods for optimizing your dbt project - dbt Coalesce 2023

Ian and Niall share their learnings and best practices on dbt optimization at dbt's 2023 Coalesce conference in San Diego.

Error Notifications for Snowflake Tasks
By Tomáš SobotíkSep 26, 20238 min read

Error Notifications for Snowflake Tasks

In this post Tomáš of Tietoevry does a deep dive into how to set up Slack error noticications for Snowflake Tasks using Amazon SNS.

Analyzing your DAG to identify unused dbt models in Snowflake
By Jay SobelAug 21, 20239 min read

Analyzing your DAG to identify unused dbt models in Snowflake

In this post, Jay does a deep dive into how you can identify unused dbt models in Snowflake by analyzing your DAG and the historical access patterns.

Effectively using the MERGE command in Snowflake
By Andrey BystrovAug 15, 202310 min read

Effectively using the MERGE command in Snowflake

In this post Andrey of Deliveroo does a deep dive into the Merge statement in Snowflake, how to effectively use it, and how it compares to other alternatives.

Every Major Announcement at Snowflake Summit 2023 and 1 Word Never Mentioned
By Ian WhitestoneJul 5, 202311 min read

Every Major Announcement at Snowflake Summit 2023 and 1 Word Never Mentioned

In this post we provide a deep dive into all Snowflake Summit 2023 announcements, why they matter and which ones we're most excited about.

Insights from Niall on dbt Labs' Analytics Engineering Podcast
By Ian WhitestoneApr 6, 20232 min read

Insights from Niall on dbt Labs' Analytics Engineering Podcast

In the podcast, Niall shares practical insights and actionable steps that organizations can take to effectively manage and reduce their Snowflake costs.

Identifying unused tables in Snowflake
By Ian WhitestoneMar 19, 20235 min read

Identifying unused tables in Snowflake

Removing unused tables in your Snowflake account can reduce spend, increase security and improve overall warehouse usability. In this post, we show how to identify tables that have not been accessed recently.

How to use Query Timeouts in Snowflake
By Ian WhitestoneMar 18, 20233 min read

How to use Query Timeouts in Snowflake

Query timeouts are an important tool for Snowflake users looking to control costs and prevent accidental cost spikes. In this post we’ll cover why they’re useful and how they can be configured.

Controlling Costs with Snowflake Resource Monitors
By Ian WhitestoneMar 17, 20235 min read

Controlling Costs with Snowflake Resource Monitors

A comprehensive guide to resource monitors and alerting to control spend in Snowflake.