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 ...
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 ...
I often hear people referring to SQL engines running against HDFS or object storage as MPP. Strictly speaking this is incorrect. Let me first explain what an MPP database is and then explain why engines such as Presto etc. should not be called an MPP engine. MPP In an MPP engine we evenly distribute data across all of the nodes ...
In this guide we will show you how to process FpML XML files with Enterprise Flexter and convert it to Oracle. FpML XML Standard FpML (Financial products Markup Language) is a business information exchange standard based on Extensible Markup Language (XML) that enables business-to-business over-the-counter (OTC) financial derivative transactions online by following W3C standards.[1] Freely available with an open-source license, ...
As there are a lot of definitions on what constitutes a data lake let’s first define what we actually mean by it. A data lake is similar to the staging area of a data warehouse with a couple of core differences. Let’s look at the commonalities first. Just like the staging area of a data warehouse the data lake stores ...
