by Dan Galavan | Jun 17, 2022 | Blog, Data Modeling, Snowflake, Snowflake Data Cloud, Uncategorized
One of the many new feature announcements at this year’s Snowflake Summit was Snowflake Unistore Hybrid Tables. The Hybrid Table offering stores data to support fast single-row transactions along with storing the data in columnar format. In other words: The...
by Dan Galavan | Feb 7, 2022 | Analytics, Blog, Data Governance, Data Integration, Data Modeling, Data Warehouse, Open Data, Secure Data Sharing, Snowflake, Snowflake Cloud Data Platform, Snowflake Data Cloud, Snowflake Data Marketplace, Snowflake Data Sharing, The Third Wave of Open Data
Data sharing including cloud-based data marketplaces are appearing at a growing rate to match data consumers with the right data suppliers. Data sharing has a long history in academic, research, and public policy circles. In more recent years it has made enormous...
by Dan Galavan | Apr 14, 2021 | Analytics, Blog, Business Intelligence, Data Flow Automation, Data Integration, Data Lake, Data Modeling, Data Vault, Data Warehouse, Snowflake Data Cloud
A data model is a communication tool Data models are core components of a successful data pipeline, whether formally or informally. They influence how Data Engineers develop the desired data transformation logic. Data models support data governance, data...
by Dan Galavan | Oct 8, 2020 | Analytics, Blog, Business Intelligence, Data ingestion, Data Lake, Data Modeling, Data Vault, Data Warehouse, DataLakeHouse, Snowflake Cloud Data Platform
Data Vault physical Data Model designed for the Snowflake Cloud Data Platform using SQLDBM Following on from my recent presentation at the virtual Munich Data Modeling Meetup on how to optimize the Data Vault architecture on Snowflake, along with the session...
by Dan Galavan | May 20, 2020 | Analytics, Blog, Business Intelligence, Data Warehouse, PowerBI, Snowflake
Do come join me on the 25th May at the Microsoft Community Café to walk through the architectural principles of the Snowflake cloud data warehouse, the enhanced PowerBI Snowflake connector, and see both PowerBI and Snowflake in action....