Metriql sso authentication with snowflake

[chenxuanrong]

Description

Metriql server wasn't able to initiate connection to snowflake through SSO.

My understanding is Metriql reads connection from profiles.yml and use that to connect to target database. From the error information, I suspect SSO is not supported in Metriql yet?

Error Information

dbt-test-framework git:(main) ✗ /Users/chenxuan.rong/metriql/metriql-0.3/bin/metriql generate
Exception in thread "main" Invalid config: java.lang.IllegalArgumentException: Instantiation of [simple type, class com.metriql.warehouse.snowflake.SnowflakeWarehouse$SnowflakeConfig] value failed for JSON property password due to missing (therefore NULL) value for creator parameter password which is a non-nullable type
 at [Source: UNKNOWN; line: -1, column: -1] (through reference chain: com.metriql.warehouse.snowflake.SnowflakeWarehouse$SnowflakeConfig["password"])

Context

dbt profiles

dbt-test-framework:
  outputs:
    dev:
      account: <account>
      authenticator: externalbrowser
      database: <database>
      role: <role>
      schema: <schema>
      threads: 4
      type: snowflake
      user: <username>
      warehouse: WAREHOUSE_XS

  target: dev

[buremba]

Yes, we don't support SSO with Snowflake yet. Thanks for reporting the feature request!