How I Built AI Command Center in Sigma for a Small Business
Most “AI in BI” demos follow the same script. Someone types a question into a chat box, a paragraph marquees back, and everyone nods. It looks impressive for about 30 seconds, until someone asks so what or what happens next. I wanted to build something different for our Tasty Bytes demo in Sigma, an imaginary […]
How to Build Sigma Metrics on Related Columns (and Keep Join Pruning)
As part of my ongoing obsession with data modeling (and my day job) I have continued to dive further into Sigma Data Model functionality. In a recent exploration of feature parity between Sigma Data Models and Snowflake Semantic Views (a topic for another day), I ran into a familiar limitation on Sigma’s relationships feature. With […]
Nobody Reads Your Docs, But the Robots Might
Documentation is for machines now. Understanding is for people later. Albert Einstein famously said, “Never memorize something that you can look up in a book.” For years, we’ve used this as a high-minded excuse to justify our own procrastination. Why bother learning the syntax when (insert AI of choice) is right there? But the goalposts […]
Big Thoughts from BigDataLDN 2026
TL;DR: Everyone has/is/does “AI.” Governance is the biggest topic. BI 2.0 is no longer interesting. Two weeks ago, I spent a day-and-a-half at the BigDataLDN (BDL) conference in London to get the temperature of the technology and sentiment of the data world. BDL is one of the biggest conferences for data in the UK, with […]
Advanced Row-Level and Column-Level Security in Sigma with User Attributes
Implementation tricks and practical advice for restricting rows and protecting columns with user attributes. The first part of this series covered the fundamentals: What row-level security (RLS) and column-level security (CLS) are in Sigma, where each one is configured, and how a basic rule is written. This second part picks up where that left off […]
InterWorks Blog Roundup — September 2026
It’s officially autumn around the InterWorks headquarters! The days grow shorter, the weather cooler and the leaves more colorful around our neck of the woods. You’ll hear no complaints from us on that front. Nor will you hear any complaints from us about our blog content this past month! (Not my best segue, but they […]
Row-Level Security and Column-Level Security in Sigma 101
A practical guide to restricting rows, protecting columns and enforcing both. Sigma gives you two complementary tools for controlling who sees what in your data: Row-level security (RLS), which controls which rows a user can see, and column-level security (CLS), which controls which columns a user can see. Used together, they let a single data […]
How I Built a Defining Millennial Songs App in Sigma
A few months ago, a friend sent me a link to an NPR Music podcast episode about identifying the defining Millennial song. Of course, no single song can define an entire group of people born within a 15-year span, but I really enjoyed pondering what might be the top songs. This came up right around […]
Bridging Transactional and Analytical Worlds with Snowflake Postgres
A B2B order fulfillment scenario. It’s common to build implementations around transactional systems: an application writing new records into a database, an event triggering an orchestration step or a stream of individual transactions landing somewhere to be processed being common examples of it. A question that comes up often is how these transactional systems interact […]
Trust, but Verify: Getting Better Data Analysis with Claude Cowork
Data Analysis questions are among the most common questions I see from clients on the Assist desk. Now that AI has entered the chat, so to speak, I get a lot of questions about using AI to analyze, clean and work with data to make the crunching of numbers, especially numbers contained in large and […]
