Testing SQL queries in production environments presents unique challenges that every data engineering team faces. When working with BigQuery, Snowflake, Redshift, Athena, or Trino, traditional testing approaches often fall short: Fragile integration tests that break when production data changes Slow feedback loops from running tests against full datasets Silent failures during database engine upgrades that […]
Instead of building custom integrations for a variety of AI assistants or Large Language Models (LLMs) you interact with — e.g., ChatGPT, Claude, or any custom LLM — you can now, thanks to the Model Context Protocol (MCP), develop a server once and use it everywhere. This is exactly as we used to say about […]
With the rapid growth of cloud technologies and data centres, it is no longer a matter of if organizations should move to the cloud — it is a matter of when and how. Cloud migrations become critical in this context, with the need to balance key levers such as speed, cost, risk, and value. Originally […]
With the rapid growth of cloud technologies and data centres, it is no longer a matter of if organizations should move to the cloud — it is a matter of when and how. Cloud migrations become critical in this context, with the need to balance key levers such as speed, cost, risk, and value. Originally […]
In the era of monolithic architectures, troubleshooting was relatively straightforward: SSH into the server, grep the log files, and check CPU usage with top. In the cloud-native world — specifically within Kubernetes — this approach is obsolete. Applications are split into dozens of microservices, pods are ephemeral (spinning up and terminating automatically), and a single […]
In the era of monolithic architectures, troubleshooting was relatively straightforward: SSH into the server, grep the log files, and check CPU usage with top. In the cloud-native world — specifically within Kubernetes — this approach is obsolete. Applications are split into dozens of microservices, pods are ephemeral (spinning up and terminating automatically), and a single […]
In the world of Enterprise Performance Management (EPM), the “Financial Close” is a race against the clock. As an Architect, my goal is to ensure that when the FP&A team finishes their forecast in OneStream, that data is available in our Snowflake Data Warehouse immediately for downstream analytics. Recently, we encountered a significant bottleneck. Exporting […]
It took a little while to gain traction after Anthropic released the Model Context Protocol in November 2024, but the protocol has seen a recent boom in adoption, especially after the announcement that both OpenAI and Google will support the standard. And it’s simple to understand why. The MCP proposed to solve, with an elegant […]
Introduction The workflow for an agentic app begins when the user interacts with it, presenting a prompt via a chat interface or a form. The agent receives this prompt and analyzes it to determine the user’s intent and requirements. It can use an LLM to acquire tasks, clarify details, and break the whole into subtasks. […]
Introduction The workflow for an agentic app begins when the user interacts with it, presenting a prompt via a chat interface or a form. The agent receives this prompt and analyzes it to determine the user’s intent and requirements. It can use an LLM to acquire tasks, clarify details, and break the whole into subtasks. […]
