This article offers a comprehensive, step-by-step guide for integrating Azure Blob Storage with a Snowflake account hosted on AWS using storage integration. It covers key topics such as setting up permissions, creating storage integration, and configuring an external stage for efficient data loading and unloading. Through practical examples, you’ll learn how to seamlessly connect Snowflake…
Category: Data Engineering
Getting Started with SnowSQL: Connecting to Your Snowflake Account
In this quick guide, we’ll walk through the essential steps to connect to Snowflake using SnowSQL, Snowflake’s powerful command-line interface. You’ll learn how to set up SnowSQL, configure your connection settings, and authenticate securely to your Snowflake account. Whether you’re new to Snowflake or just getting started with SnowSQL, this tutorial will provide a solid…
Data Modeling and its relevance in the Cloud Era
Since 2005, I’ve immersed myself in the dynamic world of data and its modeling. It’s been fascinating to witness how data modeling has evolved over the years, navigating through its challenges and successes. Throughout this journey, advocating for its significance has been a constant endeavour, emphasizing its crucial role not just as a practice, but…
Looking back to Kimball’s approach to Data Warehousing
Over time, it’s fascinating to witness how certain concepts, approaches, or visions age. Time, in its inexorable flow, often brings justice to ideas and individuals alike. Such a reflection is pertinent when considering the enduring impact of Ralph Kimball’s groundbreaking book on dimensional modeling for data warehousing and business intelligence.