Skip Navigation LinksCAIR-records-LHD-COVID-Snowflake-Job-Aid

CALIFORNIA IMMUNIZATION REGISTRY

 Snowflake Job Aid                                        CAIR Logo


To login to Snowflake, please visit the Snowflake login website.


  1.  Once you have received an invite from the CDPH directory for collaboration, youā€™ll be able to login with your organizationā€™s user details. 

    picture of email to accept login invitation

  2.  Simply click the ā€œSign in using AzureADā€ option.
    picture of login screen for Snowflake


  3.  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.
    picture showing microsoft screen to pick an account

  4.  Click the arrow in the far-right corner to set the defaults.
    picture of Snowflake screen

  5.  Make the following selections:

    1. Role = COUNTY_LHD_ROLE (Selection might vary) 
    1. Warehouse = CAIR2_VWH (Selection might vary) 
    1. Database = CA_VACCINE 
    1. Schema = PUBLIC

    picture of snowflake screen to select role

  6.  Select the Worksheets page picture showing to select the worksheets page

  7.  In the left panel, you will see ā€œCA_VACCINEā€ in the object browser, click to expand. Then click the schema ā€œPUBLICā€ and click ā€œViewsā€. 
    picture showing how to select the schema

  8.  Scroll down and locate the view ā€œVW_ALL_IIS_LHJā€. 
    picture showing how to select the view

  9.  Click on it and wait for ellipse to appear and select ā€œPreview Dataā€. 
    picture showing how to select the preview data option

  10.  Return to SQL editor and type ā€œselect top 10 * from ā€œ. 

  11.  Double click the ā€œVW_ALL_IIS_LHJā€ in the left panel for the table to appear in the SQL editor. 
    picture showing the SQL editor screen


  12.  Click the ā€œRunā€ button. 


  13. Click the ā€œdownload iconā€ button. picture showing location of the download icon


  14.  Select File Format as ā€œCSVā€ and click the ā€œExportā€ button. 
    picture showing to select CSV for export results


  15.  File will begin to download. 
    picture showing the downloaded file

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


Page Last Updated :