Observe 4 Snowflake - Native App Install Instructions¶

Install Instructions¶

To install the app you must have at least ACCOUNTADMIN role for your Snowflake user. There are two primary app configuration steps:

SQL Statements - these are SQL statements that grant the Observe For Snowflake Native App the proper permissions. These steps are required to complete the UI configuration steps.
UI Configuration - once the app has the required access and configuration secrets set up via the Manual SQL steps, you can configure what data you wish to send to Observe.

UI Configuration¶

The Observe 4 Snowflake Native App UI provides two left-hand tabs:

Setup Instructions - There are setup instructions embedded into the app for all Snowflake related configuration. This includes any manual SQL that needs to be run.
App - This is where all app configuration settings are managed, including which tables to monitor, scheduling, as well as status information.

The O4S UI provides flexibility in determining what ACCOUNT_USAGE history and objects you wish to collect and send to Observe. Furthermore, Observe 4 Snowflake supports the collection of EVENT TABLE logs, metrics and traces. Lastly, you can also select arbitrary tables or views, and send them to Observe.

For all collection cases, you can start and suspend each task individually by editing the RUNNING column, or collectively via the Suspend All and Start All buttons. Note that after you make changes to the SCHEDULE or RUNNING columns you must click Save Changes

Observe For Snowflake - App Config UI account usage

There are two access requests that can be facilitated via the UI as well.

ACCOUNT_USAGE and TASK Execution If these privileges have not been granted, there will be a pop-up dialog in the top right enabling you to do so upon page refresh.

Grant Access to a Warehouse in the Account If privilege on a warehouse has not been granted, there will be a pop-up dialog in the top right enabling you to do so upon page refresh.

Observe For Snowflake - App Config UI warehouse

Developer Tools¶

O4S provides a Developer Tools area that you can reach via the left-nav. Developer tools provides a UI to interact with the data collection tasks that O4S runs in your Snowflake account. These are advanced configuration options that you can use to fine tune and troubleshoot the behavior of O4S.

TASK Details¶

This provides an overview of the various data collection task names, schedules and states. The NAME column can be used to target changes to task properties.

Alter TASK Properties¶

This provides a mechanism to change the configuration for task suspensions, based on error responses from the Observe ingest endpoint (default is 0, which will be infinite retries). It also allows you to set the timeout for task execution (default is 24 hours or 86400000 milliseconds).

Clear STREAM¶

Clearing the stream is only intended in emergency cases, and will cause all current data to be clears and unrecoverable. Consult with Observe support if you believe you need to clear the O4S stream.