Snowflake Job Aid ![CAIR Logo CAIR Logo](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-Users/CAIRlogo-new-197x42.jpg)
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.
![picture of email to accept login invitation picture of email to accept login invitation](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/1_login_invite_1.png)
-
Simply click the āSign in using AzureADā option.
![picture of login screen for Snowflake picture of login screen for Snowflake](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/2_snowflake_login.png)
-
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 picture showing microsoft screen to pick an account](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/3_microsoft_pick_account_1.png)
-
Click the arrow in the far-right corner to set the defaults.
![picture of Snowflake screen picture of Snowflake screen](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/4_snowflake_screen.png)
-
Make the following selections:
- Role = COUNTY_LHD_ROLE (Selection might vary)
- Warehouse = CAIR2_VWH (Selection might vary)
- Database = CA_VACCINE
- Schema = PUBLIC
![picture of snowflake screen to select role picture of snowflake screen to select role](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/5_snowflake_role.png)
-
Select the Worksheets page ![picture showing to select the worksheets page picture showing to select the worksheets page](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/6_selecting_worksheets.png)
-
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 picture showing how to select the schema](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/7_select_schema.png)
-
Scroll down and locate the view āVW_ALL_IIS_LHJā.
![picture showing how to select the view picture showing how to select the view](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/8_select_view.png)
-
Click on it and wait for ellipse to appear and select āPreview Dataā.
![picture showing how to select the preview data option picture showing how to select the preview data option](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/9_select_preview_data.png)
-
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. ![picture showing location of the download icon picture showing location of the download icon](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/13_download_icon.png)
-
Select File Format as āCSVā and click the āExportā button.
-
File will begin to download.
![picture showing the downloaded file picture showing the downloaded file](/Programs/CID/DCDC/CAIR/PublishingImages/Pages/CAIR-records-LHD-COVID-Snowflake-Job-Aid/15_download.png)
-
Click to open the file and save where you need it.