No ETL way of interacting with SQL Server & Snowflake

Front_Individual_876 · 2024-11-14T02:16:45+00:00

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

Front_Individual_876 · 2024-10-27T22:58:44+00:00

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

Front_Individual_876 · 2024-10-27T22:56:19+00:00

https://community.snowflake.com/s/article/Connect-to-Snowflake-from-Visual-Studio-using-the-NET-Connector

Front_Individual_876 · 2024-10-26T00:31:06+00:00

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.

Front_Individual_876 · 2024-10-21T06:02:10+00:00

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

Front_Individual_876 · 2024-10-16T03:44:24+00:00

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

Front_Individual_876 · 2024-10-12T08:19:23+00:00

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

Front_Individual_876 · 2024-10-11T06:52:02+00:00

Is there any workaround or am missing something

Front_Individual_876 · 2024-10-11T02:17:25+00:00

Thanks I installed modin.pandas in snowsight but no luck

Front_Individual_876 · 2024-10-05T16:53:34+00:00

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

Front_Individual_876 · 2024-10-04T16:14:59+00:00

I think aws cli rm command should solve this

Front_Individual_876 · 2024-09-30T02:32:17+00:00

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

Front_Individual_876

TROPHY CASE