Data Vault 101

Data Vault Architecture Introduction The data vault is typically described as a hybrid of traditional star schema and third-normal-form (3NF) warehouse architectures. The data vault architecture addresses several of shortcomings of 3NF like rigidity and easily breaks with change or hard to add additional data sources. Unlike a star schema design, a data vault architecture normalizes andContinue reading “Data Vault 101”

Configure Single Sign On for Snowflake with Azure AD

In this article, I will show you how to integrate Snowflake with Azure Active Directory (Azure AD). When you integrate Snowflake with Azure AD, you can: Control in Azure AD who has access to Snowflake. Enable your users to be automatically signed-in to Snowflake with their Azure AD accounts. Manage your accounts in one centralContinue reading “Configure Single Sign On for Snowflake with Azure AD”

Working with Snowflake DW using SnowSQL

Snowflake’s Data Cloud is powered by an advanced data platform provided as Software-as-a-Service (SaaS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built on any existing database technology or “big data” software platforms such as Hadoop.Continue reading “Working with Snowflake DW using SnowSQL”