[EPIC] Improve Snowflake destination to satisfy General Availability criteria

[sherifnada]

Tell us about the problem you're trying to solve

GA criteria described here require that a connector achieve a good degree of reliability. This epic is a placeholder for any work required to improve the Snowflake destination such that it achieves GA status. Some things to keep in mind:

1. Measurement & visibility: we'll need to have a way to measure how well this connector is doing in the wild, and some sort of error reporting to reliably make improvements. These are captured by the following issues Experiment with Sentry performance monitoring for BigQuery destination #9328 and Setup analytics project for tracking metrics #8638
2. Absent measurement & visibility we could look at open issues for guidance, including snowflake's recommended best practices

Describe the solution you’d like

Snowflake in GA

[sherifnada]

next steps:

• catalogue all open issues, determine which ones need to happen for GA - Done by Andy here
• sync up w liren about the benchmark work and whether it overlaps for snowflake GA - Liren will finish his benchmark work and then we can start with benchmarking
• other items to figure out what is needed to get Snowflake into GA - Identified missing features in snowflake
• [ ]

[subodh1810]

Next step issues :

• Update the issue with the checklist in this doc and mention where we stand
• Snowflake : Investigate removing Insert/GCS/S3 load methods  #9602
• Snowflake : Audit snowflake destination setup UX #9607
• Snowflake Metababse metrics #9615
• Snowflake : Benchmark snowflake destination in cloud and identify potential issues #9614
• Snowflake : Support for Airbyte cloud to work with Snowflake network policies #9603 - If this is not too much work then only included

[subodh1810]

We have decided to go ahead and release Snowflake in GA