One of the benefits of being recognised as a Snowflake ❄️ Data Superhero is that I received one of the first hardcopy’s of; “Rise of the Data Cloud”. A book written by Snowflake’s CEO and Chairman Frank Slootman and freelance writer and video storyteller Stephen Hamm.
This book covers; “How Snowflake enabled a global network of organizations to connect, collaborate, and achieve with data”. This all happens in the #Cloud, where Data can be more effectively integrated, managed and mobilised.
Over the holiday season I had some time to read this book and I must say, for me it is…
Since last week Snowflake went public. Snowflake now is publicly available for trade on the New York Stock Exchange. What this Snowflake IPO means is explained on the Snowflake blog by Frank Slootman, Snowflake’s CEO.
“Frank Slootman completes his trilogy”
With the the Snowflake IPO, CEO Frank Slootman completes his trilogy. Snowflake’s CEO was already enjoying his long earned retirement. In his career he already brought two different IT companies to the public stock exchange. Both Data Domain (2102) as well as ServiceNow (2017) went public under his watch. …
Today, Wednesday 15 July, I had the privilege to present at the first online Snowflake ❄️ GROUP BY Data Heroes online event. For me personally a great opportunity to get more involved into the Snowflake Community. A fantastic chance to help others and myself to get better.
Since early 2018 I have developed an interest in Snowflake, the Data Warehouse built for the Cloud. Although I have been working with Oracle for almost the whole of my professional live, it made perfect sense to me to also have a look at Snowflake. Not in the last place because some of the founders came from Oracle. When I started looking at Snowflake, I knew I wanted to get certified too. Last year at the first Snowflake Summit in San Francisco I received the first one; Hands-On Snowflake — Web UI. Now it was time to go for the…
Last week I wrote about the newly released Matillion Data Loader (MDL). Matillion Data Loader is a Code-free, Wizard-based Pipeline builder. My first MDL Data Pipeline was loading an Excel sheet into Snowflake. Creating Data Pipelines in Matillion Data Loader is relatively easy and straightforward. Time to try something else. This time I will be loading BigQuery (GBQ) into Snowflake. Again I will show how to go from Source to Cloud Data Warehouse in a few clicks.
First add the Google Big Query Pipeline to select data from GBQ.
Introducing Matillion Data Loader to load data from GCP into SnowflakeAs you might know I am managing the Data & Analytics unit at Pong. One of my responsibilities is setting the direction of this unit. One of our focus points is Modern Cloud Analytics. Therefor we have setup a few partnerships focussed on the Snowflake Eco-system. You can find out more about these partnerships; here. Unfortunately only in Dutch, but Google Translate might help a bit. Matillion is one of those partners from the Snowflake Eco-system.
A few weeks ago I found out that Matillion is launching Matillion Data Loader…
In this folder the following scripts:
Next, follow Venkatesh Sekar’s tips and try the following:
Good luck setting up your own Snowflake Sandbox. If you run into any issues, please let me know. I will do my upmost to help you out.
Thanks for reading.
Originally published at http://www.daanalytics.blog.
In de wereld van Data & Analytics gaat het vaak over oplossingen in de Cloud. Wat is dat dan, de Cloud? Heel simpel gezegd; De Cloud is de computer van iemand anders. De waarheid ligt iets gecompliceerder. Men spreekt bij de Cloud over; ‘as-a-Service’. Een Cloud provider (Amazon, Microsoft, Google, Oracle, etc.) levert een service, die je af kunt nemen en waar je (naar gelang gebruik) voor betaalt. Geen investering vooraf.
Grofweg verdelen we de Cloud in 3 smaken: 1. Software-as-a-Service (SaaS) — Eindgebruikers gebruiken software zoals Office 365 2. Platform-as-a-Service (PaaS) — Ontwikkelaars gebruiken een BI Platform zoals Looker…
Gisterenavond was de kick-off van ‘ Cloud Analytics Now’. Dit is een initiatief van Johan van der Kooij en Rogier Werschkull.
Johan van der Kooij (de founding father van BI Dutch) gaf een korte introductie van het hoe en het waarom van ‘Cloud Analytics Now’. In goed Nederlands: “With the rise of fully managed, as-a-service cloud solutions for your data pipeline, data orchestration, analytics and data science, we believe the time to start your data / analytics migration to the cloud is now!”.
As promised in a previous blog, I will have a look at the SqlDBM partnership with Snowflake. According to SqlDBM it “offers you an easy, convenient way to design your database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps”. With SqlDBM you can both Forward Engineer (generate SQL) as well as Reverse Engineer (import an existing Database Schema). Check out more details about the the SqlDBM partnership with Snowflake here.
Using SqlDBM is as easy as navigating to; https://sqldbm.com/Home/ and sign-in (or sign-up first).
With Forward Engineering, SqlDBM…