search

newrelic-experimental / newrelic-snowflake-integration

New Relic integration with Snowflake to monitor query performance, logins, potential security incidents, optimise warehouse and cloud credit costs, capture any data stored in Snowflake for real-time alerting and reporting
Apache License 2.0
13 stars 17 forks source link

After Snowflake integration, data not available under SnoflakeAccount/Warehouse events #34

Open hemamovishub opened 2 years ago

hemamovishub commented 2 years ago

I followed all the steps, I did not get any error. I could not figure out which would be the issue .

Screen Shot 2022-08-08 at 11 31 52 AM
adlangx commented 2 years ago

This issue may have a solution

https://github.com/newrelic/newrelic-snowflake-integration/issues/22#issuecomment-1003318715

hemamovishub commented 2 years ago

I see errors as below under dimensions

/bin/sh: 1: 477628NEWRELIC_SNOWFLAKE_HOME/snowflakeintegration-macos: not found

adlangx commented 2 years ago

Try looking in the flexconfig that you put in the /etc/newrelic-infra/integrations.d directory (I think in your case it would be the flex-snowflake-mac.yml config). Replace $$NEWRELIC_SNOWFLAKE_HOME in that config with the actual path, for example /home//newrelic-snowflake-integration/

hemamovishub commented 2 years ago

Yes I tried but not able to see the metrics yet

adlangx commented 2 years ago

I have the same issue. It appears that changing to the path instead of the variable had worked for someone in an earlier issue. I am not sure why it is not working now.

hemamovishub commented 2 years ago

I replaced the path, still not working.

adlangx commented 2 years ago

Can you see if the Snowflake user that you have in the config.yml logs in when you restart the service?

adlangx commented 2 years ago

We had a query that was hanging. Perhaps the same issue.

See #35

hemamovishub commented 2 years ago

After I replaced the path, I am getting this error message:

/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/errors.js:218 throw createError(errorTypes.MissingParameterError, ^ Error [MissingParameterError]: A user name must be specified. at createError (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/errors.js:535:15) at Object.checkArgumentExists (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/errors.js:218:11) at new ConnectionConfig (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/connection/connection_config.js:142:12) at createConnection (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/core.js:73:7) at Object.createConnection (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/core.js:97:16) at Object. (/snapshot/newrelic-snowflake-integration/snowflake.js:87:26) at Module._compile (pkg/prelude/bootstrap.js:1320:22) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1156:10) at Module.load (internal/modules/cjs/loader.js:984:32) at Function.Module._load (internal/modules/cjs/loader.js:877:14) { code: 404003, sqlState: undefined, data: undefined, response: undefined, responseBody: undefined, cause: undefined, isFatal: undefined }

thatguythat1031 commented 1 year ago

After I replaced the path, I am getting this error message:

/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/errors.js:218 throw createError(errorTypes.MissingParameterError, ^ Error [MissingParameterError]: A user name must be specified. at createError (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/errors.js:535:15) at Object.checkArgumentExists (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/errors.js:218:11) at new ConnectionConfig (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/connection/connection_config.js:142:12) at createConnection (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/core.js:73:7) at Object.createConnection (/snapshot/newrelic-snowflake-integration/node_modules/snowflake-sdk/lib/core.js:97:16) at Object. (/snapshot/newrelic-snowflake-integration/snowflake.js:87:26) at Module._compile (pkg/prelude/bootstrap.js:1320:22) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1156:10) at Module.load (internal/modules/cjs/loader.js:984:32) at Function.Module._load (internal/modules/cjs/loader.js:877:14) { code: 404003, sqlState: undefined, data: undefined, response: undefined, responseBody: undefined, cause: undefined, isFatal: undefined }

I had this same error and found that the problem was specifying credentials.username instead of credentials.user in the config.yaml file.