Dan Flippo – Medium

Pinned

Dan Flippo
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

dbt Constraints: Automatic Primary Keys, Unique Keys, and Foreign Keys for Snowflake

dbt Constraints is a new package that generates database constraints based on the tests in a dbt project. Based on the very positive…

5 min readMay 3, 2022

--

1

dbt Constraints: Automatic Primary Keys, Unique Keys, and Foreign Keys for Snowflake

--

1

Pinned

Dan Flippo
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Connecting Oracle BI to the Snowflake Data Cloud

Why use Oracle BI with Snowflake?

13 min readApr 2, 2021

--

3

Connecting Oracle BI to the Snowflake Data Cloud

--

3

Dan Flippo
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Loading CSV as Semi-Structured Files in Snowflake

One of Snowflake’s interesting capabilities is being able to load semi-structured files into a column with the VARIANT data-type…

3 min readSep 26, 2022

--

3

Loading CSV as Semi-Structured Files in Snowflake

--

3

Dan Flippo
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Parsing embedded HTML tables in Snowflake Using a Java User Defined Table Function

In this article, I will demonstrate how we can extend the text parsing capabilities of the Snowflake Data Cloud using a Java User Defined…

2 min readDec 9, 2021

--

Parsing embedded HTML tables in Snowflake Using a Java User Defined Table Function

--

Dan Flippo
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Using DSN-less ODBC Connections from Alteryx and other software to the Snowflake Data Cloud

This article demonstrates how to create DSN-less connections from Alteryx and R to Snowflake

4 min readDec 8, 2021

--

Using DSN-less ODBC Connections from Alteryx and other software to the Snowflake Data Cloud

--

Dan Flippo
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Using Rclone to Migrate Data from Oracle into Snowflake

Learn how to use rclone with Snowflake

4 min readApr 9, 2021

--

1

Using Rclone to Migrate Data from Oracle into Snowflake

--

1

Dan Flippo

Dan Flippo

Sr Solutions Architect @Snowflake; SME: dbt, Kafka, Oracle BI & DB, StreamSets, Vertica. Views & opinions are my own and do not represent those of my employer.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams