Snowflake COVID-19 Vaccination Data Repository
CA counties now have access to a COVID vaccination data repository built on the Snowflake platform. Before requesting access, please note that the Snowflake data repository is nothing more than that – it’s just a centralized access point for authorized data users to download COVID-19 doses administered data – nothing more. There are no tables or graphs or summaries – just raw data to download and users will need to know SQL commands to download the data.
To request county user access, send an email to firstname.lastname@example.org
Snowflake and other data resources
Health Plan Access
Health plans registered with CAIR2 to run HEDIS reports will now be eligible to run COVID-19 patient match reports and receive back CAIR2 COVID-19 vaccine doses received by their members. Input file formatting will be the same as for HEDIS Patient Match Report (PDF) and output files will be in comma-delimited format (.csv) and adhere to the Snowflake COVID-19 Vaccination Data Dictionary (updated 1/18/2023) format.
- Place COVID input file in your assigned HEDIS sFTP folder. Make sure to name file: HealthPlanName_COVID_YYYYMMDD to distinguish it from regular HEDIS input files. Only one file per health plan per week will be allowed and the file size must not exceed 2M rows.
- Health plan contact will send email to Kavitha.Perumal@cdph.ca.gov with ‘COVID file uploaded’ in the subject line and include file name in body of email to indicate new file has been uploaded.
- Health plan contact will receive email when output file is ready for retrieval (48-72 hrs). The COVID output file will be named: HealthPlanName_COVID_OUTPUT_YYYYMMDD.
- Patients who have chosen to lock their record in accordance with California Health and Safety Code 120440 will not be returned in the COVID output file for Health Plans.