Oracle SQL Developer Data Modeler with Snowflake

Federico Sicilia Oracle, Snowflake

Why Oracle SQL Data Modeler Oracle Sql Developer Data Modeler (SDDM) is a free-to-use data modeling tool born to support developers while designing their database, or architecture, at a logical, relational or physical level, even storing and versioning changes in an easy and comprehensible way. However, if you are a data engineer, then you might have already used it at ...

Comparing Snowflake cloud data warehouse to AWS Athena query service.

Uli Bethke Snowflake

In this blog post we look at the commonalities and differences between the Snowflake cloud data warehouse and the AWS Athena query service. AWS Athena is built on top of open source technology Presto DB. As of the day of publishing, it does not support all of the features of Presto. Utility billing for data analysis Both platforms implement a ...

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.

Sampling in Snowflake. Approximate Query Processing for fast Data Visualisation

Martin Goebbels Snowflake

Introduction Making decisions can be defined as a process to achieve a desirable result by gathering and comparing all available information. The ideal situation would be to have all the necessary data (quantitatively and qualitatively), all the necessary time and all the necessary resources (processing power, including brain power) to take the best decision. In reality, however, we usually don't ...

Connecting a Zeppelin Notebook to Snowflake in under 5 minutes

Dorian Beganovic Snowflake

About Notebooks In this blog post we will show you how easy it is to connect Zeppelin notebooks to Snowflake Cloud Data Warehouse. We will also execute some queries and visualize the results using Zeppelin’s built-in tools. Notebooks are useful for exploratory data analysis, data discovery and data storytelling. As they are web based they can be shared between different ...

Exploding polygons in Snowflake. KaBooom! Visualising Dublin property data in Tableau.

Dorian Beganovic Snowflake, Tableau

Introduction In this blog post we will show the power of Snowflake UDFs to prepare data for visualisation in Tableau. We take the Irish Census Data from the Central Statistics Office of Ireland and use Snowflake to prepare the dataset for visualization in Tableau. As we have already loaded and pre-processed the Irish Census dataset for this blogpost we are ...