SNOW-944696: SQL Compilation Error when running snow streamlit deploy command

[mashhype]

SnowCLI version

2.0.0-dev

Python version

3.9.6

Platform

macOS-13.5.2-arm64-arm-64bit

What happened

When I run the following command:
snow streamlit deploy cars-app --file=Home.py -c mashsf --replace --query-warehouse MED_COMPUTE_WH
I get a SQL compilation error

FYI - I have already granted permissions as found in this link: https://docs.snowflake.com/en/developer-guide/streamlit/about-streamlit#label-streamlit-access-requirements

Console output

Exception message:
001003 (42000): SQL compilation error:
syntax error line 1 at position 32 unexpected '-'.
syntax error line 1 at position 32 unexpected '-'.
syntax error line 2 at position 0 unexpected 'ROOT_LOCATION'.

How to reproduce

I'm not sure.

[mashhype]

Adding in a few screen shots of the deploy command with --debug stacktrace.

[sfc-gh-turbaszek]

@mashhype Thanks fr the information but the full SQL error is missing from the screenshots (the text after SQL complation error). However you posted that you see there unexpected 'ROOT_LOCATION' please check if the account you use is part of streamlit PrPr.

[mashhype]

Hi @sfc-gh-turbaszek, can you share with me documentation on how to check if account is part of streamlit PrPr?

[sfc-gh-turbaszek]

Closing as the issues was with using - in unquoted identifier for streamlit app.