Support for Posit Workbench with `connect.external.snowflake`

[blairj09]

As described in the docs, connect.external.snowflake provides a PositAuthenticator class where you can define a local_authenticator (most examples use "EXTERNALBROWSER":

connect.external.snowflake.PositAuthenticator(
    self
    local_authenticator=None
    client=None
    user_session_token=None
    audience=None
)

It would be really nice if this more closely matched connect.external.databricks where you can define a default_strategy, workbench_strategy, and connect_strategy:

def cfg():
    session_token = session.http_conn.headers.get("Posit-Connect-User-Session-Token")
    return databricks_config(
        posit_default_strategy=databricks_cli,
        posit_workbench_strategy=WorkbenchStrategy(),
        posit_connect_strategy=ConnectStrategy(user_session_token=session_token),
        host=os.getenv("DATABRICKS_HOST"),

As it stands today, building something with Python in Workbench and then deploying to Connect with OAuth credentials for Snowflake is still a bit of an auth headache.

[blairj09]

Here's an example of how we're currently trying to handle this in demo apps: https://github.com/sol-eng/snowflake_demo/blob/main/apps/shiny-python-querychat/app.py#L92-L117

[kmasiello]

+1.
And this Cookbook example should be updated to reflect this strategy - https://docs.posit.co/connect/cookbook/content/integrations/snowflake/python/