Category: Snowflake
-
Prompt Engineering Inside Snowflake: Tuning AI for Performance and Personality
Welcome back to our Snowflake + AI series, where we’ve been peeling back the layers of how prompt engineering actually works inside your data warehouse. Today, we’re getting hands-on — tuning the knobs that shape how your AI sounds, behaves, and sometimes… argues with you. Because just like a guitar amp, an AI model in…
-
Data-Driven AI in Snowflake: Feeding LLMs Without Losing Control
If you’ve been experimenting with Snowflake Cortex or external LLM calls, you’ve probably hit that moment when your prompts start pulling data dynamically… and your results get a little odd. One day, it’s spitting out perfect business summaries.The next day, it’s writing fan fiction about your sales metrics. Welcome to the messy middle — where…
-
Reusable Prompts in Snowflake: Building Templates That Actually Rock
If your first foray into AI inside Snowflake felt like a garage band session — noisy, creative, but a little out of tune — you’re not alone. Most data engineers start by hardcoding prompts in their SQL or Python scripts, quickly realizing they’ve got eighteen slightly different versions of “summarize this data” scattered across their…
-
Prompt Engineering Inside Snowflake: Data, AI, and a Little Bit of Rock ‘n’ Roll
If you’ve been living under a data warehouse, here’s your wake-up call: AI is moving into Snowflake, and prompt engineering is the backstage pass. Forget “build once, run everywhere.” We’re in the “train once, prompt forever” era — and Snowflake’s native integration with LLMs means your data can finally stop waiting for its turn on…
-
The Intelligent Data Warehouse — How Snowflake Meets AI
…and right now, the same goes for AI in your data stack. For the last decade, everyone has been talking about “data-driven decision-making” as if it were some new religion. The problem? Most warehouses still act like a library from 1999. You can borrow the books, but heaven forbid you ask them to summarize themselves.…
-
Complete Guide to Snowflake’s Tag-Based Masking (Now With Auto-Tagging)
IntroductionIf you’ve followed our site for a while, you would have seen in a previous post how powerful tag-based masking policies are in Snowflake. They let you enforce consistent data masking rules across columns without constantly rewriting logic. But Snowflake hasn’t stopped there—recent enhancements now make it even easier to classify, tag, and mask data…
-
Level Up Your Snowflake Dashboard: Filters Making Audits Less Sucky
Snowflake Dashboards can do a lot more than just show pretty numbers. Today, let’s focus on something that every data pro eventually has to deal with—filters that make navigating your dashboards less painful, especially when it comes to everyone’s favorite task: AUDITING. Ah yes, auditing—because nothing says “data dream job” like tracing permissions. Whether it’s…
-
Making Snowflake Flow Better: Cleaner Queries
In a recent Snowflake release, a slick new operator quietly entered the scene: ->>. This little guy can make certain query workflows both more readable and more efficient—especially when you’re dealing with multi-step commands like SHOW, LIST, or DESCRIBE. The Classic Way: RESULT_SCAN(LAST_QUERY_ID(-1)) You may already be familiar with the pattern below: Effective? Sure. Readable?…
-
Warehouse Usage by the Hour: Because Idle Resources Still Cost Money
In our last few posts, we’ve looked at how to: Today, we’re diving into a different, but equally powerful question: When are my Snowflake warehouses actually running? This can give you some great insight into usage patterns, process timing, and maintenance windows. The Query: Mapping Warehouse Usage by Hour & Day Let’s start with the…
-
Spotting Idle Warehouses Before They Burn Through Your Budget
Now that we’ve loaded our Costs Dashboard with all sorts of goodness, let’s take it a step further and make it even more useful. The goal: track unused warehouses to help manage spend and reduce clutter. Step 1: Snapshot the Current State of Warehouses First, we’ll create a table to capture the current state of…