Global Impact of COVID-19 Template

Sigma offers a one-click template to create presentation-ready dashboards displaying global COVID-19 data from Snowflakes Data Marketplace. 

Summary of Content

Requirements
Access COVID-19 Data in Snowflake
Create a New Global Impact of COVID-19 Dashboard
Related Resources

Requirements

  • You must be an organization Admin in Sigma.
  • A Snowflake data warehouse connected to Sigma

Access COVID-19 Data in Snowflake

This template uses the Starschema COVID-19 Epidemiological Data available from Snowflake’s Data Marketplace. To access this data, visit the Marketplace from your Snowflake console, and search for COVID.

Create a New Global Impact of COVID-19 Dashboard

  1. If you have not already, add Snowflake's COVID-19 data to your warehouse using.
    To access this data, visit the Snowflake's Marketplace from your Snowflake console, and search for Starschema COVID-19 Epidemiological Data.
  2. Once your data is available in Sigma, navigate to your Sigma Home Page.
  3. Under DASHBOARD TEMPLATES, select your desired template: Compute Cost, User Adoption, or Performance Monitoring. If it doesn't appear on the main page, click VIEW ALL.
    Screen_Shot_2021-01-12_at_2.19.24_PM.png
  4. When you select a template, you will be shown a preview of that template along with a list of tables and columns needed to successfully use the template.
    Screen_Shot_2021-01-12_at_4.52.08_PM.png
  5. First, you will need to select a data source to use with the template.
    Sigma will attempt to select the appropriate data source. If one more data source options are found, they will be listed. 
    Screen_Shot_2021-01-12_at_4.53.15_PM.png
    If we were able to find a match, select your source and a location for your new dashboard. Then click Create
    From here you will automatically be redirected to your new dashboard.
    If we were unable to match data in your warehouse to the selected template, you will be prompted to manually select your data sources from the Advanced Table Mapping View.  
    IMPORTANT: There is no need to continue with the instructions below UNLESS you intend to manually select your data source(s).
  6. Select a connection and click Next.
    Note: This step will be skipped automatically if you only have access to one connection.
  7. Select data source tables from the provided lists. Then click Next.
  8. Select a destination for your new dashboard and its sources.
    Note: If creating a new folder using the Create Folder button, don’t forget to name and open the folder before continuing.
  9. Click Add.
    From here you will be routed directly to your new dashboard.

Related Resources

Dashboard Templates: An Overview
Salesforce Templates
Snowflake Usage Templates
Lacework Dashboard Templates