Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to delete default value once set for an parameter while deploying snowpark stored proc #1992

Open
sfc-gh-gmahadevan opened this issue Jan 14, 2025 · 0 comments

Comments

@sfc-gh-gmahadevan
Copy link

SnowCLI version

3.0.1

Python version

3.11.9

Platform

macOS-15.2-arm64-arm-64bit

What happened

While trying to deploy snowpark stored procedure via snowflake CLI, we could specify default value for an argument. But if we tried to remove after its being set, we couldn't remove and it still remains.

procedures: - name: "CICD_SP" database: "<% ctx.env.DB_NAME %>" schema: "<% ctx.env.SCHEMA_NAME %>" handler: "Demo.main" runtime: "3.11" signature: - name: "start_time" default: "test_default_value" type: string returns: string

Image

Console output

snow snowpark deploy --replace                                                                            ░▒▓ ✔  5s   10:56:19  ▓▒░
Performing initial validation
Checking remote state
Preparing required stages and artifacts
  Creating (if not exists) stage: gmahadevan_schema.deployment
  Uploading Demo_code.zip to @GMAHADEVAN_TEST.gmahadevan_schema.deployment/CICD/
Creating Snowpark entities
  Creating procedure gmahadevan_test.gmahadevan_schema.CICD_SP
+---------------------------------------------------------------------------------------------+
| object                                                       | type      | status           |
|--------------------------------------------------------------+-----------+------------------|
| gmahadevan_test.gmahadevan_schema.CICD_SP(start_time string) | procedure | packages updated |
+---------------------------------------------------------------------------------------------+

How to reproduce

create store proc using
procedures: - name: "CICD_SP" database: "<% ctx.env.DB_NAME %>" schema: "<% ctx.env.SCHEMA_NAME %>" handler: "Demo.main" runtime: "3.11" signature: - name: "start_time" default: "test_default_value" type: string returns: string

and the deploy it.

After deploying if we try to deploy again removing default: "test_default_value" it doesn't remove.

create store proc using
procedures: - name: "CICD_SP" database: "<% ctx.env.DB_NAME %>" schema: "<% ctx.env.SCHEMA_NAME %>" handler: "Demo.main" runtime: "3.11" signature: - name: "start_time" type: string returns: string

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant