Snowflake as destination is very very easy to work with on fivetran. Fivetran didn't have S3 as destination till late 2022. So it literally forces you to use one of BQ, Snowflake, redshift as destination.
So fivetran CEO's defence is pretty stupid.
The Snowflake community is rife with information dumps on how to optimize expensive queries. We know because we combed through a ton of them. We present three tactical ways in which we’ve done this at Toplyne.
This simple command line tool will create the directory and the file in it in one command.
Often times when I am adding test cases in pycharm, I have this frustrating experience where I have to manually create the directory & the test_file manually before I can start writing my tests. This utility has simplified my life drastically.