David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: Most or Least Privileged AccessRole-Based Access Controls (RBAC)Apr 27, 2022Apr 27, 2022
David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake & Count: A New SQL Notebook Experience for the AnalystA look into Snowsight, Snowflake’s notebook experience.Mar 28, 20211Mar 28, 20211
David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceCreate Nested JSON from Tables and Views with SQL in SnowflakeSnowflake’s native handling of JSON in both READ and WRITE operations is by far and away my favourite feature. For reading JSON I love:Jan 12, 20214Jan 12, 20214
David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceHybrid Relational JSON Tables in SnowflakeHow to use hybrid JSON tables in Snowflake. Store important fields as columns, and the rest as JSON without sacrificing performance.Dec 24, 20201Dec 24, 20201
David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceHands-on with the Snowflake Data Marketplace, Wunderman and COVID-19Learn how to use the Snowflake Data Marketplace with a real example and walkthrough.Dec 15, 2020Dec 15, 2020
David A SpeziainBigDataDaveTableau & Snowflake: COVID-19 by County Quadrants & Maps fixing Utah CountiesLast week I published a blog article showcasing how to create a COVID-19 quadrant scatter plot by county and turn the quadrants into a map…Nov 30, 2020Nov 30, 2020
David A SpeziainBigDataDaveTableau & Snowflake: COVID-19 by County Quadrants & MapsWith the COVID-19 crisis worsening in America right now, I was curious which areas of the country are being affected more than others? I…Nov 22, 2020Nov 22, 2020
David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSnowflake: VS Code, SQL Tools and GitHubVSCode plugins for Snowflake that make life easier.Nov 21, 20201Nov 21, 20201
David A SpeziainSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceVisualizing Task Hierarchies and Dependencies in Snowflake SnowsightLearn how to gain insights like runtime, execution history, and dependencies of Snowflake TasksNov 16, 2020Nov 16, 2020
David A SpeziainBigDataDaveTableau & Snowflake: Pass-Through SQL with Session Variables and ParametersWith pass-through SQL in Tableau and Snowflake you can set session variables in Snowflake to deliver on a variety of use cases. You can…Sep 22, 2020Sep 22, 2020