SNOW-1491518: Deploy does not handle schema names that begin with a number

[jhollowell]

SnowCLI version

2.4.1

Python version

3.11.9

Platform

macOS-13.6.6-arm64-arm-64bit

What happened

I have a valid Snowflake schema called 3_DAYS. (I know this is probably not best practice, but it's what is currently in our production system at the moment). When I attempt to deploy a snowpark app to the schema, it fails because the SQL being executed does not wrap the schema name in quotations.

Console output

> snow snowpark deploy

An unexpected exception occurred. Use --debug option to see the traceback. Exception message:

001003 (42000): 01b51efd-0002-538c-0000-33558f3d4982: SQL compilation error:
syntax error line 1 at position 31 unexpected '.3'.
syntax error line 1 at position 31 unexpected '.3'.
syntax error line 1 at position 38 unexpected '.'.
syntax error line 1 at position 58 unexpected 'comment'.

How to reproduce

1. Configured my config.toml as follows:

default_connection_name = "dev"

[connections]
[connections.dev]
account = "XXX"
user = "XXX"
role = "XXX"
authenticator = "externalbrowser"
warehouse = "XXX"
database = "TEMP"
schema = "3_DAYS"

2. Ran snow snowpark init and configured snowflake.yml as follows:

definition_version: 1
snowpark:
  project_name: "my_project"
  stage_name: 'my_deployment'
  src: "app/"

  procedures:
    - name: hello_procedure
      handler: "procedures.hello_procedure"
      signature:
        - name: "name"
          type: "string"
      returns: string
    - name: test_procedure
      handler: "procedures.test_procedure"
      signature: ""
      returns: string

3. Built the project with snow snowpark build
4. Attempted to deploy the sample project to the TEMP."3_DAYS" schema with snow snowpark deploy. The CLI failed with the console output attached in the form and the below query is what failed

create stage if not exists TEMP.3_DAYS.my_deployment comment='deployments managed by Snowflake CLI'

[sfc-gh-turbaszek]

The solution maybe to use `schema = '"3_DAYS"' to specify it as quoted identifier. Quoted identifiers are bit tricky in cli context.