4 ms·

Would that be to support SSO? If so, I haven't planned it yet but I could. Would that make this more useful to you?

chrisjc 2y ago
It should be just as easy as adding: authenticator="externalbrowser" Adding a Snowflake connection configuration option that allowed for standard Snowflake connection conventions might be a good option. That way you could connect to Snowflake with your existing configurations (.snowsql/, .snowflake/). Or explicitly specify by adding matching args/params to your project's config. # myconf.toml [test-connection] account=mysfaccount authenticator="externalbrowser" ... # config/config.yaml source: type: snowflake connection: file_path: test-connection name: ./myconf.toml change_tracking_database: melchi_cdc_db change_tracking_schema: streams sf.connect(connection_name=?, connections_file_path=Path(?).resolve())
- ryanwaldorf 2y ago
  Thank you! Will take a look at this over the next few days
- ryanwaldorf 2y ago
  I just pushed the external_browser branch to github that should offer 1/ externalbrowser authentication and 2/ the ability to use TOML files with profiles with instructions on how in the readme. if you run the following you should be able to test it out. git clone https://github.com/ryanwith/melchi.git git pull external_browser # remaining steps are the same Would you mind testing it out and letting me know if it works for you? Would really appreciate it! You can also let me know if it works in discord here: https://discord.gg/bTg9kJ92 https://discord.gg/bTg9kJ92
pratio 2y ago
absolutely, without sso, I can't even try it. Our policies don't allow using a password.
- ryanwaldorf 2y ago
  just replied to chrisjc that I created a branch with externalbrowser auth and pushed it to github. would you mind taking a look and letting me know if it works for you? would love to get your feedback as I don't have SSO set up in my account to test this myself
  - pratio 2y ago
    thank you, will try and let you know

It should be just as easy as adding: authenticator="externalbrowser" Adding a Snowflake connection configuration option that allowed for standard Snowflake connection conventions might be a good option. That way you could connect to Snowflake with your existing configurations (.snowsql/, .snowflake/). Or explicitly specify by adding matching args/params to your project's config. # myconf.toml [test-connection] account=mysfaccount authenticator="externalbrowser" ... # config/config.yaml source: type: snowflake connection: file_path: test-connection name: ./myconf.toml change_tracking_database: melchi_cdc_db change_tracking_schema: streams sf.connect(connection_name=?, connections_file_path=Path(?).resolve())

ryanwaldorf 2y ago
Thank you! Will take a look at this over the next few days
ryanwaldorf 2y ago
I just pushed the external_browser branch to github that should offer 1/ externalbrowser authentication and 2/ the ability to use TOML files with profiles with instructions on how in the readme. if you run the following you should be able to test it out. git clone https://github.com/ryanwith/melchi.git git pull external_browser # remaining steps are the same Would you mind testing it out and letting me know if it works for you? Would really appreciate it! You can also let me know if it works in discord here: https://discord.gg/bTg9kJ92 https://discord.gg/bTg9kJ92

pratio 2y ago

absolutely, without sso, I can't even try it. Our policies don't allow using a password.

ryanwaldorf 2y ago
just replied to chrisjc that I created a branch with externalbrowser auth and pushed it to github. would you mind taking a look and letting me know if it works for you? would love to get your feedback as I don't have SSO set up in my account to test this myself
- pratio 2y ago
  thank you, will try and let you know