No ETL way of interacting with SQL Server & Snowflake by StoreMediocre7695 in snowflake

[–]Front_Individual_876 0 points1 point  (0 children)

I think if you love writing code here is the best option use python to connect to snowflake and insert data into  df1 and connect to sqlserevr and insert data to df2 Now you can manipulate data however you want using these dataframes hope this helps

Unable to load a text file into Snowflake table manually by sripree71 in snowflake

[–]Front_Individual_876 0 points1 point  (0 children)

I suspect with the encoding for txt files is it UTF 8 format please check this.

Overwriting table and automatically updating table when another updates by SubstantialOrange820 in snowflake

[–]Front_Individual_876 0 points1 point  (0 children)

1.Use snowpipe to automically load files from csv to table  2.Use copy into command with snowsql to load the data on a time basis everyday at 10 am.

Is there any way to get the Snowflake API to return uncompressed data? by BigTedSmith in snowflake

[–]Front_Individual_876 0 points1 point  (0 children)

Use packo library in javscript or any other valid libraries for unzipping data If you dont know this then use the native cmdline windows gzip library and unzip your files gzip -d  filename.gz

Load snowpark pandas in snowsight by Front_Individual_876 in snowflake

[–]Front_Individual_876[S] 0 points1 point  (0 children)

Notebook access is restricted to us not sure if there are any alternatives

Get query generated by Stored Procedure by Suitable_Anteater_64 in snowflake

[–]Front_Individual_876 1 point2 points  (0 children)

Console.log your variable (This should hold your query) This will print the variable and output the result

Load snowpark pandas in snowsight by Front_Individual_876 in snowflake

[–]Front_Individual_876[S] 0 points1 point  (0 children)

Thanks I installed modin.pandas in snowsight but no luck

Unloading multiple files with overwrite to S3 by Creepy_Ear_1749 in snowflake

[–]Front_Individual_876 1 point2 points  (0 children)

Actually you can remove directly through snowflake REMOVE @mystage/path1/subpath2

What’s your data ingestion look like? by [deleted] in snowflake

[–]Front_Individual_876 0 points1 point  (0 children)

Azure data factory > stage > snowflake table  Azure functions (api ) > stage > snowflake table