Frequently Asked Questions

When installing OpsCenter from the Snowflake Marketplace it’s important to wait at the OpsCenter Marketplace listing until you get confirmation that the application has been installed. This typically takes 2-5 minutes. If you navigate away the native app may fail the install.

This is indicative of having navigated away during the install process. You can no longer ‘Install’ but can’t ‘Open’ either. See the next question for a resolution.

You will have to uninstall and reinstall the OpsCenter app. You can do this by going to ‘Apps’ and at the far right of the row for OpsCenter there is a ... button. Click on this to bring up a menu of options, and select “Uninstall”. You can then go back to the OpsCenter Marketplace listing listing to reinstall the app. Be sure to remain on the Marketplace Listing page until you receive a confirmation email from Snowflake.

The first launch of OpsCenter will take longer than subsequent launches of the app, and will display a blank screen with a “Please Wait …” banner at the top. This will persist from between 30 seconds to 2 minutes.

If you have waited more than 2 minutes to see the ‘Welcome To Sundeck OpsCenter’ page, then the App may have failed to run. In the ‘Activity’ screen in Snowsight look for the EXECUTE STREAMLIT ... query. If this query is not in the ‘Running’ state then try to re-start the app by going back to the ‘Apps’ pane in Snowsight and starting OpsCenter again. Note that OpsCenter (and the associated EXECUTE STREAMLIT ... query) will stop running if the OpsCenter application is not in focus in the browser.

Some Snowflake customers are using PrivateLink or have otherwise set restrictive network or firewall policies which only allow requests from specific domains or IP address ranges to be made from the Snowflake UI. If you are using such a policy, you will need to ensure that requests to *.snowflake.app are allowed, otherwise the “Please Wait …” message will be shown forever.

Ensure you are running the queries with the correct role (usually ACCOUNTADMIN). The supplied SQL script grants permissions to the OpsCenter app to create tables and perform actions, and require elevated permissions to do so.

Ensure you ‘right click’ and ‘Open link in new tab’ rather than just click on the link. This is a known Streamlit issue that should be fixed by mid-July 2023. If you open the link in a new tab in a new tab, you will be able to sign up for a free Sundeck account, and create the requested token for OpsCenter.

Yes, you can share your Sundeck account URL with your team. Any Snowflake user in your account can use the Sundeck flows you have created. To give other users access to the Sundeck UI, please see the section on collaboration.

The OpsCenter native app uses a background task to materialize the data used for reports. This is done as a Serverless Task and may take some time to complete depending on the size of query history. The following steps are useful to troubleshoot:

1. Look at ‘Activity’ -> ‘Task History’. The QUERY_HISTORY_MAINTENANCE and WAREHOUSE_HISTORY_MAINTENANCE tasks should show their last completed state. If failed go to next step, if running then please be patient while the job completes.
2. Run the following in a Snowsight sql worksheet:

   select *
    from table(information_schema.TASK_HISTORY())
    where database_name='OPSCENTER'
   

   And look for the failed task. If the task failed in approximately 1h then it’s likely the task timed-out. Otherwise, the error may be more substantial and we recommend joining the Sundeck Community slack. Posting the error message/code and some further details.
3. In the case of a timeout the serverless task will run again with a larger warehouse. This will likely be all that is required. Otherwise you can increase the timeout by running the following in a Snowsight sql worksheet:

    call opscenter.admin.run_as_app('BEGIN
      alter task opscenter.tasks.query_history_maintenance suspend;
      alter task opscenter.tasks.query_history_maintenance set USER_TASK_TIMEOUT_MS = 7200000 USER_TASK_MANAGED_INITIAL_WAREHOUSE_SIZE = \'LARGE\';
      alter task opscenter.tasks.query_history_maintenance resume;
   END;');   
   

Please make sure that connection to NativeApp is healthy by navigating to Settings/Connection as demonstrated below.

If notifications are still not working as expected after it was confirmed that connection is healthy, please follow steps below:

• If you are trying to “Notify Author” in your query monitor, make sure the Snowflake user has their “email” field set in their Snowflake profile. You can set an email address for the user either via SQL or through the Snowflake Snowsight UI. If you make any changes to the email addresses for users, please run the query execute task OPSCENTER.TASKS.SFUSER_MAINTENANCE , before attempting to test the query monitor again.

• If you are trying to “Notify Others” in your Query Monitor, we enforce a limitation that you may only configure email addresses that have the same domain as the email you used when signing up for Sundeck. For example, when signed up with the email address robert@sundeck.io, you may only send emails to other addresses that end with “@sundeck.io”.

• The Native App also exposes a view with details that you can query: select * from opscenter.reporting.query_monitor_activity order by action_time desc limit 10. This query will return the ten most recent actions taken by query monitor. The outcome column from this query may point us to a specific issue.

• Lastly, if email notifications are still not working as expected, it might be that your query monitor condition does not match query as it appears in INFORMATION_SCHEMA.QUERY_HISTORY() To validate query monitor condition, write a query that selects from INFORMATION_SCHEMA.QUERY_HISTORY with exact WHERE clause that you specified in the query monitor you are trying to get to work. If query was not found in query history, it means your condition is invalid needs to be modified.