David A Spezia – Medium

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: Most or Least Privileged Access

Role-Based Access Controls (RBAC)

4 min readApr 27, 2022

--

Snowflake: Most or Least Privileged Access

--

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake & Count: A New SQL Notebook Experience for the Analyst

A look into Snowsight, Snowflake’s notebook experience.

6 min readMar 28, 2021

--

1

Snowflake & Count: A New SQL Notebook Experience for the Analyst

--

1

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Create Nested JSON from Tables and Views with SQL in Snowflake

Snowflake’s native handling of JSON in both READ and WRITE operations is by far and away my favourite feature. For reading JSON I love:

3 min readJan 12, 2021

--

4

Create Nested JSON from Tables and Views with SQL in Snowflake

--

4

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Hybrid Relational JSON Tables in Snowflake

How to use hybrid JSON tables in Snowflake. Store important fields as columns, and the rest as JSON without sacrificing performance.

5 min readDec 24, 2020

--

1

Hybrid Relational JSON Tables in Snowflake

--

1

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Hands-on with the Snowflake Data Marketplace, Wunderman and COVID-19

Learn how to use the Snowflake Data Marketplace with a real example and walkthrough.

5 min readDec 15, 2020

--

Hands-on with the Snowflake Data Marketplace, Wunderman and COVID-19

--

David A Spezia
in
BigDataDave

Tableau & Snowflake: COVID-19 by County Quadrants & Maps fixing Utah Counties

Last 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…

3 min readNov 30, 2020

--

Tableau & Snowflake: COVID-19 by County Quadrants & Maps fixing Utah Counties

--

David A Spezia
in
BigDataDave

Tableau & Snowflake: COVID-19 by County Quadrants & Maps

With the COVID-19 crisis worsening in America right now, I was curious which areas of the country are being affected more than others? I…

6 min readNov 22, 2020

--

Tableau & Snowflake: COVID-19 by County Quadrants & Maps

--

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: VS Code, SQL Tools and GitHub

VSCode plugins for Snowflake that make life easier.

4 min readNov 21, 2020

--

1

Snowflake: VS Code, SQL Tools and GitHub

--

1

David A Spezia
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Visualizing Task Hierarchies and Dependencies in Snowflake Snowsight

Learn how to gain insights like runtime, execution history, and dependencies of Snowflake Tasks

4 min readNov 16, 2020

--

Visualizing Task Hierarchies and Dependencies in Snowflake Snowsight

--

David A Spezia
in
BigDataDave

Tableau & Snowflake: Pass-Through SQL with Session Variables and Parameters

With pass-through SQL in Tableau and Snowflake you can set session variables in Snowflake to deliver on a variety of use cases. You can…

5 min readSep 22, 2020

--

Tableau & Snowflake: Pass-Through SQL with Session Variables and Parameters

--

David A Spezia

David A Spezia

David spends his time working with Web-Scale Data Applications built on Snowflake with the largest tenants on the Snowflake Data Cloud.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams