Troubleshooting
Neo4j Graph Analytics for Snowflake is in Public Preview and is not intended for production use. |
Below are troubleshooting steps to help identify or rule specific problems.
Ensure app privileges
During installation, the application required the following account privileges:
-
CREATE COMPUTE POOL
-
CREATE WAREHOUSE
Without these privileges, the application cannot create the necessary compute resources.
Using a role that has the necessary privileges to inspect the applications grants, run the following query.
SHOW GRANTS TO APPLICATION Neo4j_Graph_Analytics;
CREATE TEMPORARY TABLE APPLICATION_PRIVILEGES
AS SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
We now have a temporary table from which we can inspect the privileges granted to the application. Verify that the CREATE COMPUTE POOL and CREATE WAREHOUSE account privileges are granted to the application with the following query.
SELECT "privilege", "granted_on", "granted_to", "grantee_name"
FROM APPLICATION_PRIVILEGES
WHERE "privilege" = 'CREATE COMPUTE POOL' OR "privilege" = 'CREATE WAREHOUSE';
The query result should look as follows.
privilege | granted_on | granted_to | grantee_name |
---|---|---|---|
CREATE COMPUTE POOL |
ACCOUNT |
APPLICATION |
NEO4J_GRAPH_ANALYTICS |
CREATE WAREHOUSE |
ACCOUNT |
APPLICATION |
NEO4J_GRAPH_ANALYTICS |
Ensure event sharing
During the installation of the application, you were required to enable event sharing. This step is mandatory for the application to install and ensures you receive the best support experience. If the event sharing configuration has been corrupted, please reset it.
Please note that we are using the default application name Neo4j_Graph_Analytics below. If you chose a different app name during installation, please replace it with that.
For more information about event sharing, see https://other-docs.snowflake.com/en/native-apps/consumer-enable-logging
Determine status of event sharing
To view telemetry event definitions in the application:
SHOW TELEMETRY EVENT DEFINITIONS IN APPLICATION Neo4j_Graph_Analytics;
Alternatively, review the event sharing settings in Snowsight under Data Products ⇒ Apps ⇒ Neo4j Graph Analytics selecting the App events tab.
Restore status of event sharing
To restore event sharing:
ALTER APPLICATION Neo4j_Graph_Analytics SET AUTHORIZE_TELEMETRY_EVENT_SHARING = true;
ALTER APPLICATION Neo4j_Graph_Analytics SET SHARED TELEMETRY EVENTS('SNOWFLAKE$TRACES', 'SNOWFLAKE$USAGE_LOGS', 'SNOWFLAKE$ERRORS_AND_WARNINGS', 'SNOWFLAKE$DEBUG_LOGS');