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

active warehouse issue #12

Closed apinchuk closed 2 years ago

apinchuk commented 3 years ago

Hi,

I pulled the older version of the repository (1.2); however, I am seeing continuous error saying "Failed to execute statement due to the following error: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.", even though nowhere in the snowflake.env is it asking for WAREHOUSE name. However, even if I add the following parameter SNOWSQL_WAREHOUSE, I am seeing the same error. Any idea what could be the issue?

I tried using the newest version of the repository as well (1.7); however, seeing a problem of nri-flex getting pulled into infrastructure agent but not pushed to New Relic. Not sure if this is an open issue right now.

What would be the most stable version to use right now.

apinchuk commented 3 years ago

was able to resolve the issue by adding "warehouse:" key/value in the config.yml.

matewilk commented 2 years ago

Thanks for confirming you were able to solve the issue @apinchuk