Multiple snoflake account support

[asverkaltsev]

Summary

Support for multiple snowflake accounts with 1 snowflake agent

Desired Behavior

Hi, we have more than 20 accounts on SF at different regions of azure and AWS. For now we should create a new VM for each of them.
Could it be set up to connect to different accounts within 1 agent? Like have account_1: user_1,pswd_1, then _2 and so on.

Additional context

Have 20+ VMs (and set them up) just for SF is quiet a lot.

[sskirby]

@asverkaltsev have you tried using multiple config files? AFAICT each run command in the flex-snowflake.yml file can refer to a different config.yml file which is where the Snowflake account is configured.

E.g.

- run: $$NEWRELIC_SNOWFLAKE_HOME/snowflakeintegration-macos $$NEWRELIC_SNOWFLAKE_HOME/<different config here> $$NEWRELIC_SNOWFLAKE_HOME/queries/account_metering.sql