Posts

Snowflake vs Redshift: some syntax differences.

Moving code from Redshift to Snowflake

As I said here, my company is in the process of moving from Redshift to Snowflake. There are loads of reasons for doing it: to mention a few, better handling of permissions, less maintenance and less effort to optimise query performance.

A...

Let’s practice with this month #SWDchallenge.

#SWDchallenge and where to find them

One of my favourite author about data visualisation, Cole N. Knaflic, published a new book Storytelling with data: Let’s Practice!

I am keen of getting my own copy, but while waiting I decided to take part in this month challenge. If you’re interested...

Querying a Snowflake Database

My company is in the process of moving from an Amazon Redshift to a Snowflake database, and without going into the consideration of pros and cons of each, let’s see how to query data from Snowflake.

Using the...

A 3D exploding pie chart: not a good idea.

A panel in a history of printing museum

Last week I was visiting this museum about the history of invention and development of printing in Bassano Del Grappa, a small little village in the North of Italy. The museum was really well presented and it reminded me how the...