search

fixer-m / snowflake-db-net-client

Snowflake .NET Client
Apache License 2.0
51 stars 14 forks source link

CopyInto api #18

Closed gamitWeb closed 2 years ago

gamitWeb commented 2 years ago

Hi, Do you have a copy into api in the clienct senario is that I am trying to upload stagging csv file from azure blob to snowflake table also can I pass from column and to column in copy into query ?

fixer-m commented 2 years ago

Hi! Yes, uploading files from Azure Blob should work. Run your query with ExecuteScalarAsync() method. Here is the documentation for COPY INTO command. If I understood correctly, it supports column mapping, i.e. you can specify which column take from from file and to which column upload data.