Snowflake Job Aid 
To login to Snowflake, please visit the Snowflake login website.
- Once you have received an invite from the CDPH directory for collaboration, youāll be able to login with your organizationās user details.

-
Simply click the āSign in using AzureADā option.

-
If you have more than one logged in account, youāll see a prompt like below. Be sure to use the email address you received the invite to.

-
Click the arrow in the far-right corner to set the defaults.

-
Make the following selections:
- Role = COUNTY_LHD_ROLE (Selection might vary)
- Warehouse = CAIR2_VWH (Selection might vary)
- Database = CA_VACCINE
- Schema = PUBLIC

-
Select the Worksheets page 
-
In the left panel, you will see āCA_VACCINEā in the object browser, click to expand. Then click the schema āPUBLICā and click āViewsā.

-
Scroll down and locate the view āVW_ALL_IIS_LHJā.

-
Click on it and wait for ellipse to appear and select āPreview Dataā.

-
Return to SQL editor and type āselect top 10 * from ā.
-
Double click the āVW_ALL_IIS_LHJā in the left panel for the table to appear in the SQL editor.
-
Click the āRunā button.
-
Click the ādownload iconā button. 
-
Select File Format as āCSVā and click the āExportā button.
-
File will begin to download.

-
Click to open the file and save where you need it.