ERA5 Climate Data on Snowflake Marketplace

Uli Bethke May 16, 2022

ERA5 ERA5 is the fifth generation ECMWF atmospheric reanalysis of the global climate covering the period from January 1950 to present. ERA5 is produced by the Copernicus Climate Change Service (C3S) at ECMWF. Reanalysis uses modelling so that geographic areas with no directly available climate observations can be filled in to generate ‘maps without gaps’ ...

Read More

USA: ZIP+4 Codes & Address Data

Uli Bethke May 4, 2022

Overview United States ZIP codes are five numerical digits long. ZIP+4 codes, also known as add-on or plus-four codes, include four additional digits that identify a geographic segment within a ZIP code delivery area. The first digit in a ZIP code represents a defined group of U.S. states. The second and third digits represent a ...

Read More

Best Practices for implementing a Data Lake on Snowflake

Uli Bethke April 20, 2022

Data lakes. An introduction Data lakes are a common and useful design pattern in modern data architecture. Contrary to a widespread belief, data lakes have been around for a long time. The designs by Ralph Kimball and Bill Inmon included the design pattern of a staging and landing area. These are the parents of the ...

Read More

Converting Workday XML to Snowflake

Uli Bethke March 30, 2022

Overview In this post we will show you how you can easily convert Workday XML or any other XML to a Snowflake database. We will use Sonra’s Paranoid to mask the XML data and Flexter to convert Workday XML automatically without any manual coding. What is Flexter? Flexter converts any XML/JSON to a readable format ...

Read More
1 2 3 4 25