Configuring Private endpoint to Snowflake Private link using managed Virtual Network

Hi, 

Thank you for the article. This is really useful and this is exactly what we are trying to achive it with our current project. We have thirdparty data provider using snowflake DW and we are trying to extract data out of it & do our ETL in ADF. I have a few question if you don't mind.

• How would you copy the data out of snowfalke to your azure storage? 
• What would your source & sink would be in the copy activity? I assume the source would be snowflake and for the sink, would you create a linked service to your ADLS (or blob) via managed private endpoint? Or, would you enable staging at the copy activity? Will both work? 
• Would it be possible to use snowflake internal stage via the managed private endpoint connections- if so,  would you know how the link service be authenticated? 

Hope you can help. Thanks a lot!