Video Archives - Data Ideology

Video Articles & Insights

A Better Way to Start with Snowflake Cortex Code

There’s a pattern starting to emerge with teams adopting AI inside Snowflake and it’s actually a good one. It usually starts the same way. A few engineers get access to Cortex Code. They start experimenting. Someone builds something interesting. Others join in. Ideas start flowing. Use cases begin to take shape. This is exactly what […]

In Snowflake, Not All Nulls Are the Same

You might assume null is null and that is the end of it. That assumption will burn you in Snowflake. When you are working with semi-structured data, there is a real difference between a key that is missing and a key that exists with a JSON null value. Those are not the same thing, and […]

If You Are Running Tiny Batch Loads All Day, You May Have Rebuilt Snowpipe Poorly

A lot of teams create fake real-time ingestion by brute force. They schedule COPY INTO jobs every few minutes, keep shrinking the interval, and call it responsiveness. That is usually just manual effort pretending to be architecture. The hard truth is that Snowpipe and COPY INTO are not radically different ideas. Snowpipe is essentially the managed, continuous version of […]

When COPY INTO Fails, Stop Playing Detective

Too many teams still treat load failures like a scavenger hunt. A file breaks, the load dies, and someone opens the CSV to start eyeballing rows like Snowflake could not possibly tell them what went wrong. That is a waste of time. If COPY INTO fails, the goal is not to guess better. The goal is to […]

If Your Query Got Faster Only the Second Time, You May Not Have Fixed Anything

Think your Snowflake query got faster? It might just be cache. Learn how result caching skews performance testing and leads to false optimizations.

AI Data Tools Start To Separate Fast When One Thinks With You

Compare Snowflake Cortex Code vs Databricks Genie and see which AI analytics tool better supports thinking, workflow momentum, and insight generation.

Stop Treating Snowflake Cortex Code Like a Demo Toy

Most teams are looking at Snowflake Cortex Code the wrong way. They see a slick interface, a faster way to write SQL, or a flashy AI feature to test for five minutes and forget. That misses the point. Cortex Code matters because it lowers the barrier between business questions and real analytical action inside Snowflake. […]