Not getting Snowflake data after install

[henman75]

We have installed the NR Flex Snowflake integration but getting the following error in the infra debug log:

time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="custom storer name: com.newrelic.nri-flex and TTL: 1m0s"
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="store file (/tmp/nr-integrations/com.newrelic.nri-flex.json) is older than 1m0s, skipping loading from disk.""
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="Function.isAvailable: enter""
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="Function.isAvailable: exit status: false""
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=info msg=com.newrelic.nri-flex GOARCH=amd64 GOOS=linux version=1.4.4"
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="config: git sync configuration not set""
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="config: running async" name=snowflake"
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="config: processing apis" apis=12 name=snowflake"
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="fetch: collect data" name=snowflake"
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="commands: executing" count=1 name=snowflake"
time="2022-05-03T21:56:36Z" level=info msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time="2022-05-03T21:56:36Z" level=debug msg="command: failed" context_err= err="exit status 127" exec="$$NEWRELIC_SNOWFLAKE_HOME/snowflakeintegration-linux $$NEWRELIC_SNOWFLAKE_HOME/config.yaml $$NEWRELIC_SNOWFLAKE_HOME/queries/account_metering.sql" suggestion="if you are handling this error case, ignore""
...

This happens for all queries part of the standard package. Any clues on how to fix this?

[henman75]

it seems that the full path for $$NEWRELIC_SNOWFLAKE_HOME is not resolved when running as systemd and using an env file. When adding the full path in config.yaml the binary and query files will be found

[adlangx]

I still see this when adding the full path to the flexconfig:

time="2022-08-09T16:59:41Z" level=debug msg="Integration stderr (not parsed)." component=integrations.runner.Runner integration_name=nri-flex line="time=\"2022-08-09T16:59:41Z\" level=debug msg=\"command: failed\" context_err= err=\"exit status 1\" exec=\"/home/azureuser/newrelic-snowflake-integration/snowflakeintegration-linux /home/azureuser/newrelic-snowflake-integration/config.yaml /home/azureuser/newrelic-snowflake-integration/queries/pipe_usage.sql\" suggestion=\"if you are handling this error case, ignore\"" runner_uid=67a24e361f