In this post, I will guide you through the basic steps to define a new Service Account and grant different roles in BigQuery in the cloud. It is a common choice to work at the command line and manage development workflow in a terminal window.
Continue reading “Quick Guide: BigQuery Service Account Setup Using gcloud”
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 and Azure, ensuring secure data transfers and leveraging Snowflake’s staging functionality to streamline data management across cloud platforms. This guide is designed to simplify the process and enhance the efficiency of cross-cloud data operations.
Continue reading “Integrating Azure Blob Storage with Snowflake: A Guide to Storage Integration and Staging Data”
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 foundation to help you query and manage data in Snowflake directly from your terminal.
Continue reading “Getting Started with SnowSQL: Connecting to Your Snowflake Account”
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 as a cornerstone for ensuring accurate and actionable data.
Continue reading “Data Modeling and its relevance in the Cloud Era”