Using Snowsight to create and manage semantic views¶

In Snowsight, you can create and manage semantic views:

Creating a semantic view
- Using the wizard to create a semantic view
- Uploadating a YAML specification to create a semantic view
Editing a semantic view
Granting the privilege to use a semantic view to another role

Creating a semantic view¶

In Snowsight, you can create a semantic view by using a wizard or by uploading a semantic model specification.

Using the wizard to create a semantic view
Uploadating a YAML specification to create a semantic view

Using the wizard to create a semantic view¶

Note

To create a semantic view, you must use a role with the privileges described in Privileges required to create a semantic view.

Access the wizard for creating semantic views in one of the following ways:
- Database object explorer:
  1. In Snowsight, select Data » Databases.
  2. Select the database and schema where you want to create the semantic view.
  3. Select Create » Semantic View » Create with guided setup.
- Cortex Analyst:
  1. In Snowsight, select AI & ML » Cortex Analyst.
  2. Select Create new » Create new Semantic View.
In the Getting started step in the wizard:
1. From Location to store, select the database and schema where the model should be stored.
2. In Name, enter a name for your semantic view.
  
  You must specify a name that starts with a letter or underscore and that only contains letters, numbers, underscores, or dollar signs.
3. (Optional) In Description, describe the data that your semantic view makes available.
4. Select Next.
In the Select tables step in the wizard:
1. In the All tab, select the tables or views that contain the data that you want to use in your semantic view. Note the following:
  - You must select at least one table or view.
  - For better performance, don’t select more than ten tables.
  - If you want see the list of tables and views that you selected, select the Selected tab.
2. Select Next.
In the Select columns step in the wizard:
1. Select the columns to include in the view.
  
  To select all columns in a table or view, select the table or view.
  
  For better performance, don’t select more than 50 columns.
2. Select Create and Save.
Under Logical tables:
1. Review the facts, dimensions, and metrics defined for each table or view.
2. Provide business-friendly names and descriptions.
3. Add any additional facts, dimensions, and metrics needed.
Under Relationships:
1. Confirm any relationships defined by the generator.
2. Modify relationship properties as needed.
3. Add any additional relationships needed.
If you made any changes to the semantic view, select Save.

Uploadating a YAML specification to create a semantic view¶

If you are planning to create the semantic view from Cortex Analyst, create a stage for the YAML file.
Upload the YAML file in one of the following ways:
- Database object explorer:
  1. In Snowsight, select Data » Databases.
  2. Select the database and schema where you want to create the semantic view.
  3. Select Create » Semantic View » Upload YAML file.
  4. Select the YAML file to upload.
  5. Under Select database, schema and stage, select the database, schema, and stage where you want to upload the YAML file.
  6. If you want the YAML file uploaded to a specific path in the stage, specify that path.
  7. Select Upload.
- Cortex Analyst:
  1. In Snowsight, select AI & ML » Cortex Analyst.
  2. Select Create new » Upload YAML file.
  3. Select the YAML file to upload.
  4. Select Convert and save.

Editing a semantic view¶

To edit a semantic view:

Access the semantic view in one of the following ways:
- Database object explorer:
  1. In Snowsight, select Data » Databases.
  2. Select the database and schema containing the semantic view.
  3. Select Semantic views.
  4. Select the semantic view.
  5. Select the Semantic information tab.
- Cortex Analyst:
  1. In Snowsight, select AI & ML » Cortex Analyst.
  2. Select the Semantic views tab.
  3. Under Select database to see semantic views, select the database and schema containing the semantic view that you want to edit.
  4. Select the semantic view that you want to edit.
Make changes to the semantic view. You can make the following types of changes:
- To modify the name or description of the semantic view:
  1. Select Edit next to the name of the semantic view.
  2. Make changes to the name or description.
  3. Select Apply.
- To add a new logical table to the semantic view:
  1. Select + Logical Table in the database object explorer or + in Cortex Analyst.
  2. In the Select a table step in the wizard:
    1. Select the table or view that contains the data that you want to use in your semantic view.
    2. Select Next.
  3. In the Select columns step in the wizard:
    1. Select the columns to include in the view.
      
      To select all columns in a table or view, select the table or view.
    2. Select Generate logical table.
- To make changes to the name, description, synonyms, or primary key of a logical table in the semantic view:
  1. Select » Edit Logical Table next to the logical table name in the database object explorer or Edit next to the logical table name in Cortex Analyst.
  2. Make your changes to the name, description, synonyms, and primary key.
    
    If you have not specified the description or synonyms, you can select Generate fields to fill in these fields automatically.
  3. Select Save.
- To add a fact, dimension, or metric:
  1. Open the form for adding the new item:
    - In the database object explorer, select , and select Fact, Dimension, or Metric.
    - In Cortex Analyst, select + next to Facts, Dimensions, or Metrics.
  2. Enter information about the new fact, dimension, or metric, and select Add.
- To modify or remove a fact, dimension, or metric:
  1. Select Facts, Dimensions, or Metrics to display the list of facts, dimensions or metrics.
  2. For the fact, dimension, or metric that you want to change:
    - Select Edit to modify the item.
    - Select » Remove fact, Remove dimension, or Remove metric to remove the item.
- To add a relationship:
  1. Open the form for adding the new item:
    - In the database object explorer, select + Relationship.
    - In Cortex Analyst, select + next to Relationships.
  2. Enter a name for the relationship, select the tables in the relationship, and select the columns to use to join the tables.
  3. Select Add.
If you plan to use Cortex Analyst with this view, consider the following:
- Add sample queries to the Verified Queries section. Note that this section is available only in Cortex Analyst.
  - These are example queries that help Cortex Analyst understand how to use the semantic view.
  - Add queries that represent common use cases for your data.
- Add synonyms for your tables, facts, dimensions, or metrics.
  - These are alternative terms that users might use in queries.
  - Synonyms help Cortex Analyst correctly interpret user questions.
- Add custom instructions.
  - These provide additional context about how the data should be interpreted.
  - Include business rules or constraints that should be considered.
Select Save.

Granting the privilege to use a semantic view to another role¶

To grant another role the privileges to view and query a semantic view:

Access the semantic view in one of the following ways:
- Database object explorer:
  1. In Snowsight, select Data » Databases.
  2. Select the database and schema containing the semantic view.
  3. Select Semantic views.
  4. Select the semantic view.
  5. Select » Share.
- Cortex Analyst:
  1. In Snowsight, select AI & ML » Cortex Analyst.
  2. Select the Semantic views tab.
  3. Select the semantic view.
  4. Select Share.
Select the role that should be granted the privileges to view and query the semantic view.
Select Done.

This grants the SELECT and REFERENCES privileges on the semantic view to the selected role.

Querying a semantic view¶

If you are viewing a semantic view in the database object explorer, you can open a worksheet to construct a query for that view by selecting » Query with SQL.

For information on how to construct the query, see Querying semantic views.

Best practices for creating a semantic view¶

Provide clear descriptions:
- Use business terminology in all names and descriptions.
- Make descriptions detailed enough for non-technical users to understand.
Include representative user questions:
- Include questions that can help the model generator better understand your intent.
- Include variations of how questions might be asked.
Review generated suggestions carefully:
- Make sure the questions are relevant for the use case.
- Make sure the suggested relationships match your business understanding.
Test with real questions:
- After creating your semantic view, test it with actual business questions.
- Refine your semantic view, based on how well the model supports these questions.
Iterate on developing the semantic view:
- Start with a simple star schema.
- Start with core tables and metrics, then expand. We suggest three tables to keep things simple.
- Get feedback from business users, and refine your semantic view.

Troubleshooting¶

If your semantic view is not listed in the list of views, refresh the list of models (not the page itself).
If errors occur with the relationships in the semantic view, ensure that these relationships match the actual data structure.
If queries are slow, reduce the number of tables or columns.
If Cortex Analyst produces unexpected results when using your semantic view, review the facts, dimensions, and metrics in the semantic view.