sfguide-data-engineering-with-snowpark-python icon indicating copy to clipboard operation
sfguide-data-engineering-with-snowpark-python copied to clipboard

Getting error while installing udf from snowcli (using vscode or miniconda)

Open pranilrp opened this issue 1 year ago • 0 comments

Getting error while running following command:-

snow procedure create Resolving any requirements from requirements.txt... Comparing provided packages from Snowflake Anaconda... No packages to manually resolve Writing requirements.snowflake.txt file... . . . ProgrammingError: 001003 (42000): SQL compilation error: syntax error line 1 at position 26 unexpected '~'. parse error line 1 at position 37 near '76'. parse error line 1 at position 43 near '84'. parse error line 1 at position 48 near '116'. syntax error line 1 at position 59 unexpected '/'. syntax error line 1 at position 63 unexpected '.'. syntax error line 1 at position 68 unexpected '@HOL_DB.HARMONIZED.deployments/orders_update_sp'.

Error at Snowflake looks like this :-

PUT file://C:\Users\PRANIL~1\AppData\Local\Temp\tmpn63b0aay/app.zip @HOL_DB.HARMONIZED.☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺_update_sp auto_compress=false overwrite=true

SQL compilation error: syntax error line 1 at position 26 unexpected '~'. parse error line 1 at position 37 near '76'. parse error line 1 at position 43 near '84'. parse error line 1 at position 48 near '116'. syntax error line 1 at position 59 unexpected '/'. syntax error line 1 at position 63 unexpected '.'. syntax error line 1 at position 68 unexpected '@HOL_DB.HARMONIZED.deployments/orders_update_sp'.

pranilrp avatar Aug 11 '23 10:08 pranilrp