Snowflake Powers California’s Response to Coronavirus

Author: Gabriel Mullen

Snowflake News

All 58 counties in California and many state agencies now have seamless access to data to help battle the COVID-19 outbreak and help prevent future outbreaks once state and local governments relax social distancing policies.

The State of California is a Snowflake customer and is using Snowflake Cloud Data Platform to store a multitude of data sources, including the current number of COVID-19 cases across the state, the number of suspected cases, how many are receiving treatment in a hospital ICU, the number of hospital beds and ventilators in use, and the demographics of COVID-19 patients.

All of the counties and state agencies in California accessing the data stored in Snowflake are doing so with Snowflake’s revolutionary Secure Data Sharing technology. It avoids the cumbersome, costly, and often risky traditional methods of copying and sending stale data to recipients. Instead, Secure Data Sharing allows consumers of data to access live, read-only versions of the data from the state’s single source of truth stored in Snowflake, and data consumers receive all updates to the data immediately without any additional effort on their part.

„The State of California’s response to the COVID-19 emergency has been enhanced greatly by the ability to share, collaborate, and communicate data and information in new ways that are meaningful to health professionals and allied support entities during this crisis,“ said Scott Gregory, Chief Technology Innovation Officer, Office of Enterprise Technology/California Department of Technology.

In addition, the State of California has made available three live dashboards to all its counties, state agencies, and any resident who would like to remain informed about the status of COVID-19 in their county and across the state. California wants all of its citizens to have the most recent data so they feel they are part of the solution beyond adhering to social distancing policies, and Snowflake is the data source powering these dashboards:

The number of identified COVID-19 cases by county.

 

The number of confirmed or suspected COVID-19 positive patients being cared for in a hospital setting.

 

Statewide COVID-19 case statistics broken down by county and gender-based demographics.