I have a scheduled task run in Snowflake every month and dump the result to a view table called "ABC".
I run the view on the first day of every month, and manually export output to a CSV or TXT file in my local folder.
Now, I want to automate export. So every month, I want Snowflake automatically export the view ABC to my local drive. And this is where I stuck. Please advise.