Snowflake

Let DBeaver Build Your ERD from a Snowflake Data Warehouse

I was recently responding to a question about DBeaver and the ability to automatically generate an ERD. The following post will walk you through the process.   ;TLDR Looking for an easy way to create one of these?   Let’s create 3 simple tables.  A parent table with a primary key constraint and two additional …

Python, Snowflake

Python Abort trap: 6 fix after Catalina update

A couple of days ago, I update my MacOS to Catalina and immediately after that, all the Snowflake scripts I wrote in #Python started returning an Abort trap: 6 error. My initial thought was something must be a compatibility issue with either the python connector or new default terminal shell zsh. Fortunately I was wrong, …

Snowflake

Snowflake Migration using StreamSets

#OnTapToday, using @StreamSets to migrate data from your source database to Snowflake. In this post, I will walk through the process of configuring StreamSets to migrate data from my on prem DB to Snowflake. WHY You need to get some data from a source database to the Snowflake data warehouse. There were a few options …

Snowflake

Connect to Snowflake Data Warehouse with GO

In this installment, I am going to walk through the process of connecting GO to the Snowflake Data Warehouse Service (DWaaS). This tutorial requires that you have a Snowflake account. You can sign up here for a 30 day/$400.00 trial. Download and Install the ODBC Driver Once you have your account set up in Snowflake, …

Nodejs

Connect to Snowflake with Node.js Driver

This will be the first entry into my Snowflake toolbox. Today I am going to set my MacBook Pro up to connect to a Snowflake data warehouse via the Snowflake Node.js driver. This could come in handy when needing to move data between systems where direct connections are not available and you need an intermediary. …

Snowflake

Become the Change You Seek!

By the time this posts hits, I’ll be in the air heading to one of my favorite cities, San Francisco. — My Sifu, Coach Sule, has that slogan as part of his email signature, and those are words are quite fitting.  If you have been following me on Twitter, then you know that a lot …

12C

Case Insensitivity with JSON and Oracle 12c?

About a week ago, I was presenting at ECO on JSON parsing in the Oracle 12c Database and an attendee asked a great question. To summarize, Maria Colgan gave a keynote in which she noted a feature in 12c that allows you to define a column as Case Insensitive. The attendee in my session asked if …

Oracle

ODC Appreciation Day : SQL Developer

Not sure if you’ve noticed, but there have been a few changes in Oracle’s advocacy community. The Oracle Technology Network has been rebranded as The Oracle Developer Community (ODC), and the Oracle ACE and Java Champions have a new baby sibling, called the Developer Champion. In the 2nd, hopefully annual Appreciation Day (started by Tim Hall), the community …