# Semantic Model Generator

## Creating a Semantic Model in Snowflake

1\. Click "Semantic Model Generator"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/bd9e5909-3305-4be4-ae04-2533a9f627d0/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=112,306)

2\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/eb7201f5-2c54-4217-ad09-c77056a1e3dc/ascreenshot.jpeg?tl_px=0,0\&br_px=1376,769\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=474,190)

3\. Click "customer\_data"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/babb32ee-29b3-404a-8f1d-ae9d32890507/ascreenshot.jpeg?tl_px=0,0\&br_px=1376,769\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=461,255)

4\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/fd098504-913e-4f2e-ac6b-628ac2af5e54/ascreenshot.jpeg?tl_px=0,37\&br_px=1376,806\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=390,277)

5\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/5679da20-4710-4b78-94ac-9277d3440a19/ascreenshot.jpeg?tl_px=0,74\&br_px=1376,843\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=388,277)

6\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/b2362a30-8f38-4040-8b38-c940d4c27070/ascreenshot.jpeg?tl_px=0,112\&br_px=1376,881\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=389,277)

7\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/e6a9ee6d-49e8-4d6f-b1fa-8ba73387dc97/ascreenshot.jpeg?tl_px=146,110\&br_px=1522,879\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=524,276)

8\. Double-click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/f74dfdce-f015-4548-8943-e81df01783db/ascreenshot.jpeg?tl_px=145,110\&br_px=1521,879\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=524,276)

9\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/c5950eb5-d4f8-487e-800b-3e588f55df37/ascreenshot.jpeg?tl_px=164,96\&br_px=1541,865\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=726,277)

10\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/9a10b1a2-4b6d-4498-989d-7b0e059132d7/ascreenshot.jpeg?tl_px=164,109\&br_px=1541,878\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=628,277)

11\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/5e02e85d-43ee-4a4b-8983-88869cd3d451/ascreenshot.jpeg?tl_px=164,109\&br_px=1541,878\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=721,277)

12\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/97e60477-3cd0-4a8a-8437-fffde629a677/ascreenshot.jpeg?tl_px=164,105\&br_px=1541,874\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=715,277)

13\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/895bada6-ae4b-4e1f-b732-f5b7a25a2bce/ascreenshot.jpeg?tl_px=164,112\&br_px=1541,881\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=687,277)

14\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/da38a49c-46ae-4c52-93f1-c3784ceb3082/ascreenshot.jpeg?tl_px=164,106\&br_px=1541,875\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=611,276)

15\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/6ff1ad6a-81eb-4b5b-89f6-4928c6453184/ascreenshot.jpeg?tl_px=164,106\&br_px=1541,875\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=639,276)

16\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/6b93b7f8-27c6-4039-b539-c7070faf22e0/ascreenshot.jpeg?tl_px=164,101\&br_px=1541,870\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=764,277)

17\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/f3bf341c-5c77-4997-b2dc-a34c04b0ea40/ascreenshot.jpeg?tl_px=164,106\&br_px=1541,875\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=939,276)

18\. Click "Virtual Attributes"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/8dba20ff-452b-4c8d-9fc0-61a0503ea7c9/ascreenshot.jpeg?tl_px=130,32\&br_px=1507,801\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=524,277)

19\. Click the "Attribute Name" field.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/74395ddb-0ade-4879-85aa-70c27ce462b0/ascreenshot.jpeg?tl_px=0,0\&br_px=1376,769\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=454,247)

20\. Type "example"

21\. Click the "Description" field.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/644bc3d9-14d9-4cdb-b119-190cf3a3a0af/ascreenshot.jpeg?tl_px=0,51\&br_px=1376,820\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=445,276)

22\. Type "an example virtual attribute"

23\. Click "str"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/d7c0a5f3-8815-458b-ac93-457eb890dafc/ascreenshot.jpeg?tl_px=0,135\&br_px=1376,904\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=455,277)

24\. Click "int"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/a4820ab6-0ddf-4fa7-b99f-227d388ae7cb/ascreenshot.jpeg?tl_px=0,209\&br_px=1376,978\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=416,277)

25\. Click "NUMBER"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/48f04e7f-8d41-4d9a-83ec-8d2e130547e9/ascreenshot.jpeg?tl_px=0,222\&br_px=1376,991\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=477,277)

26\. Click "DECIMAL"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/9624475e-995e-4411-a488-0346e6ba1611/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=436,332)

27\. Click here.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/116b1545-e8fa-49f5-a016-3d0561351cca/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=483,337)

28\. Click "filters"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/1371187b-9991-48b8-a4a3-1d768d5a5944/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=458,463)

29\. Click "Root level (no array)"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/886675e5-cf6c-42e7-8cc6-7da604ed8640/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=502,412)

30\. Click "customerData.customers"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/38700bb1-a4cd-4f58-8593-1131bf725b9e/ascreenshot.jpeg?tl_px=0,135\&br_px=1376,904\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=489,277)

31\. Click the "SQL Expression\*" field.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/f6bdf954-d162-48a8-baa8-3b741af72692/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=475,503)

32\. Type "''"

33\. Click "Create"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/3b89c131-477c-4d4f-a2d6-fe30bfecb36b/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=447,558)

34\. Click "Create"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/dfce9d26-ba5f-4ce2-8611-4d348361f740/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=354,563)

35\. Click the "Semantic Model Instructions" field.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/5696fde4-6553-4610-9c94-709575b598e0/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=454,314)

36\. Type "Additional Instructions go here."

37\. Click "Save Instructions"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/52d2f7fe-9554-4e33-8d97-2d42dd57bf57/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=338,397)

38\. Click "Generate YAML Code"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/3ae71e9e-d26c-438d-9467-85573f6d3f34/ascreenshot.jpeg?tl_px=0,223\&br_px=1376,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=116,333)

39\. Click "itemized purchases"

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/a826ff38-809f-431f-b410-aab1caca58bd/ascreenshot.jpeg?tl_px=119,223\&br_px=1495,993\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=524,286)

40\. Click this icon.

![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-06-18/abb5f6fb-4236-42dc-95a0-6289fd036b31/ascreenshot.jpeg?tl_px=164,124\&br_px=1541,893\&force_format=jpeg\&q=100\&width=1120.0\&wat=1\&wat_opacity=1\&wat_gravity=northwest\&wat_url=https://colony-recorder.s3.amazonaws.com/images/watermarks/FB923C_standard.png\&wat_pad=991,277)

[**Made with Scribe**](https://scribehow.com/shared/Creating_a_Semantic_Model_in_Snowflake__dqN-mugtTgul1lSf3oqMFg)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.datapancake.com/guides/how-to-guides-ui/semantic-model-generator.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.