I am trying to query a table in Snowflake that is built with a single field labeled "Value" and each row is a separate JSON object. Row 1: { "artist": { "artistID": "artist_1", "artistName": "Roblox" }, "descriptors": { "styles": […
I have this data in a json column #mycolumn { "key": "KEY", "elements": [ { "name": "NAME_1" }, { "name": "NAME_2" } { "name": "NAME_3" } ] } I want to select all the elements[*].name. I have tried: select JSON_EXTRACT_PATH_TEXT(mycolumn,…
Working on creating a native application using Snowpark container service. I have created an application package and application. When I am trying to open the service endpoint - app-url.snowflakecomputing.app it gives the below error - Access denied. Insufficient privileges to…
I have written some python stored procedures in snowflake. Can I maintain this stored procedures within visual studio code IDE. I need to do the following. See code changes Modify stored procedure from vs code Ability to deploy stored procedures…
I'm encountering an issue with my Azure DevOps pipeline where I'm trying to run a snowsql command with a password retrieved from Azure Key Vault. The pipeline retrieves the secret correctly, but when I use it in the snowsql command,…
I am trying to create a view in snowflake stored procedure. I need one of the column from the variable. I tried following but getting following error, Error SQL compilation error: syntax error line 4 at position 36 unexpected '('.…
I'm trying to copy data from Salesforce to Snowflake using ADF avoiding use SAS Token, because of that I going to use integration storage on Snowflake. I'm trying to follow this example: https://medium.com/snowflake/seamless-migration-to-snowflake-using-adf-script-activity-schema-detection-25475ea86a09. I already create the integration storage, format…
I have this JSON raw data that is injected to Snowflake via Kafka from devices. I am trying to convert some of the values to a table using Snowflake's Dynamic Table (so basiacally I just need to fix the SELECT…
I have been trying to install Snowflake connector python with the command pip install snowflake-connector-python on Windows OS and getting the following error. Python version 3.12.0 LINK : fatal error LNK1104: cannot open file 'buildtemp.win-amd64-cpython-312Releasesrcsnowflakeconnectornanoarrow_cppArrowIteratornanoarrow_arrow_iterator.cp312-win_amd64.exp' error: command 'C:\Program Files (x86)\Microsoft…
Somehow my code only insert row 1 and colum1,2,3 records into output table. unfortutely it doesn't insert records row2 onwards. could someone please help? unforutely my code only insert the first row's column only. it is not iterating through remaing…