Sonra: Climate Data: ERA5

ERA5 is the fifth generation ECMWF atmospheric reanalysis of the global climate data

Description:
ABOUT
=====
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’ – complete and consistent representations of climate and atmospheric composition across time.

ERA5 provides hourly estimates of a large number of atmospheric, land and oceanic climate variables. The data cover the Earth on a 30km grid and resolve the atmosphere using 137 levels from the surface up to a height of 80km.

DOCUMENTATION
===============

We have put together a comprehensive documentation which includes a description of all of the tables and columns in the data set, sample queries, and an introduction to the core ERA5 data objects

You can view the documentation here: https://sonra.io/data-marketplace/era5-data/

ATTRIBUTION
==========

Generated using Copernicus Climate Change Service information in 2022. Neither the European Commission nor ECMWF is responsible for any use that may be made of the Copernicus information or data it contains.

TABLES
=======

The data set contains the two core ERA5 objects as tables.

1. SINGLE_LEVEL

-LONGITUDE FLOAT
-LATITUDE, FLOAT
-TIME, TIMESTAMP_NTZ(9)
-U10, FLOAT
-V10, FLOAT
-FG10, FLOAT
-D2M, FLOAT
-T2M, FLOAT
-CBH, FLOAT
-ISTL1, FLOAT
-ISTL2, FLOAT
-ISTL3, FLOAT
-ISTL4, FLOAT
-I10FG, FLOAT
-MX2T, FLOAT
-MSL, FLOAT
-MWD, FLOAT
-MWP, FLOAT
-MN2T, FLOAT
-SST, FLOAT
-SWH, FLOAT
-SKT, FLOAT
-SP, FLOAT
-TP, FLOAT
-VIMD, FLOAT

This is a subset of the available variables. For all variables go to https://sonra.io/data-marketplace/era5-variables/

2. PRESSURE_LEVEL

-LONGITUDE, FLOAT
-LATITUDE, FLOAT
-LEVEL, NUMBER(38,0)
-TIME, TIMESTAMP_NTZ(9)
-D, FLOAT
-CC, FLOAT
-Z, FLOAT
-O3, FLOAT
-PV, FLOAT
-R, FLOAT
-CIWC, FLOAT
-CLWC, FLOAT
-Q, FLOAT
-CRWC, FLOAT
-CSWC, FLOAT
-T, FLOAT
-U, FLOAT
-V, FLOAT
-W, FLOAT
-VO, FLOAT

This is a subset of the available variables. For all variables go to https://sonra.io/data-marketplace/era5-variables/

Requesting the data
==============

When requesting the data provide the following information to get a quote:

Do you require single levels, pressure levels or both
Provide start year
Provide end year
Time
Geographical areas

About the Provider:

Sonra offers products and services in data management and data analytics.

Flexter is our flagship product. It automates the conversion of industry data standards, XML, JSON to a relational model on Snowflake, relational databases, and big data formats

Sonra provides Snowflake various professional services, e.g. migration services, quickstarts.

Sonra provides data advisory services, e.g. data architecture and strategy.

Visit the provider’s website for more information

Get access to the Sonra: Climate Data: ERA5 Listing in Snowflake

SIGN UP FOR A SNOWFLAKE FREE TRIAL

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

LOGIN