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. 
   

   
   
   

2.  Simply click the “Sign in using AzureAD” option.
   
   
   
   

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.
   
   
   

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

5.  Make the following selections:
   

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

   
   
   

6.  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”. 
   
   
   

8.  Scroll down and locate the view “VW_ALL_IIS_LHJ”. 
   
   
   

9.  Click on it and wait for ellipse to appear and select “Preview Data”. 
   
   
   

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. 
    
    

    
    

12.  Click the “Run” button. 
    

    
    

13. Click the “download icon” button. 
    

    
    

14.  Select File Format as “CSV” and click the “Export” button. 
    
    

    
    

15.  File will begin to download. 
    
    

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