Ad-hoc data visualization using Claude + MotherDuck + mviz
Ad-hoc analytics using Claude Code, MotherDuck and mviz to create visualizations
Latest
Can you run dlt inside Snowflake? (Part 2/2: SPCS)
In my last post I explored whether dlt could run in a Snowflake UDF... and failed. But can it still run inside Snowflake using a Container? TL/DR: yes, it does 😎
Can you run dlt inside Snowflake? (Part 1/2: UDF)
So, dlt by dltHub runs "where Python runs"... I guess that means it should run in a Snowflake UDF, too. TL/DR: no, it doesn't 😎 But hey: negative results are results, too, right? 😅
Add an "Update Data" Button to Tableau
How to add a "Update Data" Button to a Tableau Dashboard
Snowflake Snapshots
How and why to use Snapshots in Snowflake
Microsoft Entra, SCIM and Snowflake Network Policies
When using Network Policies and Entra Provisioning to Snowflake, you either go public or combine multiple Network Rules
Salesforce to Snowflake without ELT-Tool
Let's cut out the middle-tool 😜
Asynchronous Child Jobs in Snowflake
Wait, what? Child labor?
Refresh Tableau from inside Snowflake
We don't need no orchestration!
Snowflake + Polaris + PyIceberg/DuckDB/Polars + AZURE
Is the combination of PyIceberg and Azure ready for multi-engine compute, yet?
Use Perplexity in Snowflake
Send requests to (and receive responses from) the Perplexity API using a Snowflake Snowsight notebook
Access Log Data Model
How to make sense and use of server-side tracking logs from a webserver
Digital Analytics
Conversions without cookies
How to track conversions from Google Ads and Meta without any cookies
Lakehouse
Snowflake Dynamic Tables
Dynamic Tables in Snowflake
Lakehouse
Chat with your Snowflake Data and LLMs
Use Snowflake Cortex COMPLETE in Teams via Power Automate
Digital Analytics
Multi-Input Lookup Variable in GTM
How to use lookup variables in GTM with multiple input fields
Lakehouse
Pub/Sub messages to Snowflake
Pub/Sub is an asynchronous and scalable messaging service that decouples services producing messages from services processing those messages c.f. cloud.google.com/pubsub/docs/overview Some streaming processes rely on messages being received and provided by a message bus. It doesn't really matter if this bus
Digital Analytics
Server-side tag-management and consent
Collecting consent in server-side tracking
Lakehouse
Transient Database in Snowflake
What are transient tables in Snowflake good for?
Infrastructure
Gateway Server for Data Factory
How to start a self-hosted ADF runtime when you need it and pause it when you don't?
Lakehouse
Parent-child-hierarchy in Snowflake and Tableau
Recursive queries and hierarchies in Snowflake and Tableau