Snowflake/Snowsight setup -data Module 2

Course Q&A Fast Prototyping of GenAI Apps with Streamlit
,
1

Hi,

In Module 2,Building Prototypes in Snowflake , Getting Started with Streamlit in Snowflake, the professor tells us to take the 120 days $400 free trial. Then he explains the platform look changes frequently so what we experience might differ from what can be seen in his video. For example , he clicks in the left sidebar on the data tab to explore database, schemas etc . This is not what I see , instaed under Home /Work with Data, I have Project Ingestion Transformation etc… Can you provide a link to the tutorial to the current platform please.

2d: once we have finished practicing , can you provide the procedure to follow to delete the account neatly please.

2

I will contact the course staff.

1 Like
3

another point to mention in Module 2 , Video : From STAGES to Table with Cortex where the professor shows how to extra info from unstructured data (100 files) into a table. I’m getting that the model is not available in the Region I have chosen; to allow cross region

Please advise how to proceed

1 Like
4

Thank you for reporting! Just shared it with the team and we’ll double check what you just mentioned about the platform.

About the region, that is curious :thinking: may I ask from which region are you connecting? just to double check with the Streamlit/Snowflake about this issue, please?

5

It seems not all models are available everywhere. I got a message to allow croos-region inference or something similar.

Re the platform , by digging up and doing a search , I was able to set up Database , Schemas and Stages

1 Like
6

Let’s see what your team says.

7

Hi @user440,

I’m Chanin, the course instructor, first of all thanks for enrolling in the course. In regards to the issue that you’re facing, it would be helpful to know which region you are connecting from.

To figure that out, can you run the following in a Notebook SQL cell or in a SQL worksheet:
sqlSELECT CURRENT_REGION();

For me, I’m getting the following output:
AWS_US_WEST_2

I’ve also rechecked the notebook file (M2/Lesson_01/M2L1V6.ipynb) in the course GitHub repo (github.com/https-deeplearning-ai/fast-prototyping-of-genai-apps-with-streamlit) and adjusted the line with the stage path from @AVALANCHE_STAGE to @AVALANCHE_DB.AVALANCHE_SCHEMA.AVALANCHE_STAGE to ensure that you’re in the correct path of the stage.

Also, it would be helpful if you could share a screenshot of the error that you’re encountering.

cc: @lesly.zerna

Best regards,
Chanin

1 Like
8

Hi Chanin. Thanks for proposing this course on deeplearning.ai. There are many settings in Snowflake which makes it challenging to master.

Re the region, in the video you indicate to choose the region closest to us. So I chose western Europe.

LIST @Avalanche_Stage displays the 101 files. But I will update the cell with the full path as in your updated repo.

The LLM function from Cortex doesn’t seem to be available in that region.

I DM you the details with the screenshots

@lesly.zerna

Kind Regards

9

Hi Chanin.

@lesly.zerna

The error message says among other things “The model you requested is unavailable in your region” . In the Snowflake docs, I have found the following Cross-region inference | Snowflake Documentation

1 Like
10

Hi @user440

It seems that the European region isn’t supporting the LLM model, could you try activating access to the US region by running the following SQL statement:

ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'AWS_US';

Afterwards, could you run:

SHOW PARAMETERS LIKE 'CORTEX_ENABLED_CROSS_REGION' IN ACCOUNT;

Best regards,
Chanin

1 Like
11

Hi Chanin @dataprofessor

that’s done.

The outputs are resp:

Statement executed successfully. and 
   key                              value    default     level
CORTEX_ENABLED_CROSS_REGION AWS_US DISABLED ACCOUNT

Regards
12

Hi @dataprofessor ,

Thanks.

After allowing cross region inference , I reran the cell and obtained:

| Table RAW_CUSTOMER_REVIEWS successfully created. | | | | | | |
| | |
|----|----|----|----|----|----|----|----|----|----|

I was able to read from the table.

I haven’t checked the rest of the course; I’m wondering if this cross region inference will be needed again later on (and how to switch back to default mode).

While I’m at it, I would like to know if you or someone at deeplearning.ai @lesly.zerna can provide a link explaining how to cleanly delete the Snowflake account once this course has been completed please.

Regards

13

Hi @user440

Great to hear that it works!

For the cross region inference, you can revert back to its default state:

ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'DISABLED';

If you’d like to delete a Snowflake account, you’ll have to contact Snowflake support, more info here.

Hope this helps.

Best regads,
Chanin

2 Likes
14

Hi @dataprofessor , Chanin

Thank you for the info. I will be able to continue the learning in the course.

I will also check the link on how to terminate a Snowflake trial account upon completion of your course.

Regards

3 Likes