Source Snowflake: support oauth

[sherifnada]

Tell us about the problem you're trying to solve

With the release of Airbyte Cloud, we need to start supporting Oauth for this connector, since it's the recommended way of authenticating users into a SaaS application.

If this connector doesn't support oauth already (i.e: doesn't accept a client_id and client_secret) then we need to update its spec to accept those parameters. I suggest that this be a oneof nested inside a top-level field called "authentication":

{ authentication: { type: object oneOf: [ // api key, // oauth ] } }

See the connector spec reference in the docs for reference on how a oneof can be implemented.

This should be done in a backwards compatible manner i.e: users currently supplying authentication info in the config's top-level should not be impacted by this change.

Acceptance Criteria

1. The connector supports oauth webflow authentication with client_id/client_secret
2. Oauth properties are annotated properly. See this PR for an example

[igrankova]

#10002 duplicates this issue and is in implementation
@sherifnada, I apologize, I didn't see your issue and created a new one and it's already in progress.