by Dan Galavan | Jan 27, 2026 | AI, Business Intelligence, Data Governance, Data Integration, Data Modeling, Snowflake
Introduction: Semantic Layers are not new. I first used them back in the noughties. I’ve designed, configured, and led their delivery in a variety of analytical solution initiatives, not least Enterprise Data Warehousing. I’ve worked with numerous Semantic Layer...
by Dan Galavan | Jan 29, 2024 | Snowflake, Snowflake Cloud Data Platform
Quick Snowflake Snowpark Container Services (SPCS) tip: If you are testing out SPCS and receive the following: “391811 (0A000): Unsupported feature GRANT/REVOKE CREATE COMPUTE POOL ON ACCOUNT” It may be because Snowpark Container Services is not yet...
by Dan Galavan | Nov 6, 2023 | Snowflake, Snowflake Cloud Data Platform, Snowflake Data Cloud
Snowflake Data Cloud optimization tip regarding the Search Optimization Service Background The Search Optimization Service (SOS) can be used to improve query performance for specific lookups. Use cases may be the optimization of analytical queries, or any query that...
by Dan Galavan | Oct 30, 2023 | Snowflake, Snowflake Data Cloud
Since the acquisition of Streamlit last year, significant steps have been taken in terms of integration with the overall Snowflake platform. This has recently culminated in the ability to create, run, and debug Streamlit Apps from within Snowflake using the Snowsight...
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...