PUT command Snowflake on VSCode

Question

I use the snowflake driver for SQLTools on vscode and i'm connect to my snowflake account but i'm some issues when i want to put some files with extensions .csv from my local machine to my stage in snowflake. Indeed, when i use the command put file:///mypath/file.csv @nameofmystage; it works on terminal but not in the window vscode with extension Snowflake driver. However, others commands like copy into works on the driver vscode ...

The error's message is Unsupported feature 'unsupported_requested_format:snowflake'

thanks in advance for your help

Answer 1

Not a solution or final answer, but a hint - here someone is having the same error, but with the Go-Driver: https://github.com/snowflakedb/gosnowflake/issues/227

Go didn't support PUT in this case.

Answer 2

Based on the PUT documentation, currently PUT is not supported in .NET driver.

Snowflake Driver for SQLTools does not look like a driver from Snowflake, as it was not mentioned here:

Connectors & Drivers

I am not sure how the driver is built, but given both vscode and .NET are both MS product, I assume that it is not supported, but hope others can help to verify.

Answer 3

This is not an answer for SQLTools, but if you are using Snowflake's Visual Studio Code extension, PUT is supported.

https://marketplace.visualstudio.com/items?itemName=snowflake.snowflake-vsc