Data Integrations
The systems we load into Snowflake most often, and the tools people use to read it, with what usually breaks and what we build on top.
Stores and Marketplaces
Shopify to SnowflakeShopify is usually the order record for a DTC brand. Getting it into Snowflake is quick. Getting numbers that match Shopify reports, finance and marketing takes deliberate modeling.Read more 
Amazon Seller Central to SnowflakeAmazon fees do not live in one SP-API report. We load each source for the question it answers, so fees by SKU, margin and payouts can all be checked against Amazon.Read more 
TikTok Shop to SnowflakeA TikTok Shop order settles for less than its sale price, and most of the difference sits in fields a quick report skips. We load the detail so channel margin reflects the full cost.Read more - Recharge to SnowflakeRecharge records subscription intent: charges, skips, cancels and changes. In Snowflake it sits beside Shopify orders, so each order can be labelled without counting the sale twice.Read more
Reporting and AI
- Snowflake to SigmaSigma queries Snowflake live and generates SQL that runs in your warehouse. The workbooks are only as good as the tables they read, so we model those first.Read more
- Snowflake to ExcelExcel can refresh Snowflake data through the Snowflake ODBC driver. The private key stays on the computer, Snowflake holds the public key, and a reporting role decides what the workbook can read.Read more
- Snowflake to ClaudeClaude connects to a Snowflake-managed MCP server, not straight to every table. Snowflake still controls identity, roles, warehouses, grants and query history.Read more
- Snowflake to ChatGPTChatGPT connects to a Snowflake-managed MCP server over HTTPS. No data is copied into ChatGPT and no administrator password is handed over.Read more
Using a system that isn't listed?
These are the ones we write about most, not the only ones we connect. Tell us what you run and we'll say how we'd load it.