We're here to help in

Snowflake

Access powerful, energy-relevant weather data directly from our Snowflake database. Whether you’re building forecasts, analyzing risk, or optimizing grid operations, this page provides everything you need to understand, connect, and work with our data.

Entity Relationship Diagram (ERD)

Visualize how our data is structured.

The ERD provides a high-level view of our data model, including key tables like forecasts, observations, and normals. Use it to understand relationships, join logic, and where to find the variables you need for your analysis.

Download the ERD PDF below.

Sample Python Notebook

To assist you in getting started, a sample script which just needs your Snowflake account credentials. Click below.

AG2 Table Definitions Documentation

Understand column names, data type, descriptions, and sample data for our daily and hourly data, including normals, weighted degree days, forecasts, observations, and more.

"We use Snowflake for our analytics. It’s so much easier to query the AG2 data through Snowflake, as it is a very fast database. In this industry, you don’t want to be behind in the technology you’re getting from your weather vendors."

— Anonymous Energy Trader
Scroll to Top