File doesn't exist when putting batch to internal stage using Windows machine

[pnadolny13]

From slack thread https://meltano.slack.com/archives/C01TCRBBJD7/p1689179609824739

The target uses the underlying SDK batch mechanisms to load data to snowflake via internal stages. It looks like somewhere along the way the path is getting mangled and slashes are being removed and it causes a File doesn't exist to be raised. An example is C:GitHubETLRedesignmeltano-projectMeltanoV2\target-snowflake--Content-ResourceLocationUpdate-c1b6705a-fbbc-4965-ae9c-3cf50ee17296-1.json.gz. It's very likely that this issue belongs in the SDK but this is where it was identified first.

I tried to track down whats happening but it goes into the fs library and its very difficult to debug without a windows machine to test on.

cc @edgarrmondragon @visch

[BuzzCutNorman]

Looking at the logs provided in Slack I think the error is happening when target-snowflake tries to put the file into snowflake via the target_snowflake.connector.SnowflakeConnector.put_batches_to_stage. The statement in the logs looks correct according to the snowflake put documentation :

[SQL: put 'file://C:\GitHub\ETLRedesign\meltano-project\MeltanoV2\target-snowflake--Content-ResourceLocationUpdate-c1b6705a-fbbc-4965-ae9c-3cf50ee17296-1.json.gz' '@~/target-snowflake/Content-ResourceLocationUpdate-e3a47dbf-2469-4bda-a986-9c91e1cd1b79'] 

[edgarrmondragon]

That looks like a Windows path so that's gonna make testing a bit harder for me, but yeah it's probably a 🐛 in the sdk

[visch]

We'll take a stab at this one! I have a windows machine so I should be able to dive easier!

[visch]

Taking a peak now