Tag

#snowflake

364 posts126 followers

Explore Hashnode

Alternatives

Thyne Ventures10h ago · 2 min read

Which Snowflake tables has nobody read in 90 days? One read-only query to check

Tables that nobody reads still cost storage every month, and they clutter every search for the right dataset. On Enterprise Edition or higher, Snowflake records which objects each query touched in ACC

thyneventures.hashnode.dev

Pravinraj Vincent22h ago · 7 min read

Snowflake connector 200-row cap in UiPath Integration Service: how to paginate or go async

Originally published on the UiPath Community Forum. Pravinraj Vincent, UiPath Solutions Engineer If you've moved a Snowflake query from the old activity package to the Integration Service Snowflake co

1 pravinrajvincent.hashnode.dev

Thyne Ventures2d ago · 2 min read

Is your Snowflake warehouse cache doing anything? One read-only query to check

When a warehouse suspends, its local disk cache is dropped, so the next queries read everything from remote storage again. This read-only query shows, per warehouse over the last 14 days, what share o

thyneventures.hashnode.dev

Thyne Ventures3d ago · 2 min read

Is your Snowflake warehouse too big for its queries? One read-only query to check

Bigger warehouses double the credits per hour at each size step, but they only help when queries are large enough to use the extra compute. This read-only query looks at the last 14 days and shows, pe

thyneventures.hashnode.dev

Thyne Ventures4d ago · 2 min read

Are your Snowflake warehouses burning credits while idle? One read-only query to check

A warehouse bills every second it is running, whether or not a query is executing. A long AUTO_SUSPEND or a dashboard that pings every few minutes can keep it awake all day. This read-only query compa

thyneventures.hashnode.dev

Pipeline Whiteboard5d ago · 9 min read

CDC Schema Changes: What Breaks and How to Ship Them

On Friday at 17:40, someone renamed one column in the orders table. The pipeline stayed green all weekend. On Monday, the revenue dashboard showed zero for Saturday and Sunday. Nothing failed, and tha

pipelinewhiteboard.hashnode.dev

Thyne Ventures5d ago · 2 min read

Find your costliest Snowflake query patterns with one read-only query

Most Snowflake bills are driven by a handful of repeated queries. Find them before you resize anything. This read-only query groups the last 14 days of history by query pattern and ranks them by total

thyneventures.hashnode.dev

Pipeline Whiteboard6d ago · 10 min read

CDC Deletes, Tombstones and the Idempotent MERGE

Order 1042 was deleted at 14:10. At 15:00 it's back in the warehouse, marked shipped. Nobody re-created it. A retried batch did. This is Part 4 of CDC in Production. In Part 3 we caught silent data lo

pipelinewhiteboard.hashnode.dev

Thyne VenturesOct 29 · 2 min read

Is your Snowflake warehouse queueing? One read-only query to check

Slow Snowflake dashboards aren't always slow queries. Often the query runs in two seconds but waits twenty in line because the warehouse is full. Here's a read-only query that shows which warehouses q

thyneventures.hashnode.dev

Balaji KottanaOct 27 · 10 min read

From On-Prem to a Modern Data Platform, Part 1: The Architecture End to End

Most migration write-ups stop at the target diagram: source, cloud storage, warehouse, dashboard. The diagram is the easy part. What decides whether a platform holds up in production is everything aro

datanarratives.hashnode.dev

Search Hashnode

Explore Hashnode

Trending tags this week

Which Snowflake tables has nobody read in 90 days? One read-only query to check

Snowflake connector 200-row cap in UiPath Integration Service: how to paginate or go async

Is your Snowflake warehouse cache doing anything? One read-only query to check

Is your Snowflake warehouse too big for its queries? One read-only query to check

Are your Snowflake warehouses burning credits while idle? One read-only query to check

CDC Schema Changes: What Breaks and How to Ship Them

Find your costliest Snowflake query patterns with one read-only query

CDC Deletes, Tombstones and the Idempotent MERGE

Is your Snowflake warehouse queueing? One read-only query to check

From On-Prem to a Modern Data Platform, Part 1: The Architecture End to End