Get Started with Spendview for Snowflake

Spendview for Snowflake is a free module from DataOps.live observability, a core component of our platform.

You must register to access Spendview for Snowflake. Once registered, you can add as many Snowflake accounts as needed and start monitoring them.

Signing up

From the DataOps.live website, register using your business email address to access the Spendview for Snowflake free module for the first time.

Sign up from the website

Prerequisites

• You can access Snowflake as a new user with the role DATAOPS_OBS_VIEWER, which has the necessary permissions. See Create user and warehouse for more information.
• If a firewall protects your Snowflake account, you must add our IPs to the allowlist to enable access to your account: 35.176.116.33, 3.11.127.149, and 18.170.83.22.

Register

1. In your browser, go to the DataOps.live website and click Spendview for Snowflake.

2. In the open form, enter your user information, including your business email address, and click Sign Up.

   

3. Check your inbox for the trial sign-up email.

4. In the email, read the instructions and click the activation link.

5. Set a new password, confirm it, and open the observability tool using the link provided.

6. On the login page, enter your credentials and click Sign in.

7. Click Go to Settings in the prompt message to add the Snowflake accounts you want to monitor.

   

8. Click Add Account on the top right to open a form.

9. Enter your Snowflake login information and click Submit. Learn more about how to add a Snowflake account.

   This creates and adds the account to the Snowflake Settings page.

   

   You can switch between two views to have real-time insight into the account cost — per Terabyte and credit — and the account login information. Read more about how to manage accounts.

10. Repeat the last two steps to add all the Snowflake accounts you want to monitor.

    

11. Click the Financial Observability icon on the left sidebar to open the free module and explore the Snowflake accounts' spending and usage.

Signing in

1. Click the Spendview for Snowflake link you received in the sign-up email.

2. Enter your username and password in the open form and click Sign in.

   

3. Explore the real-time visibility of the Snowflake accounts' spending and utilization using the different menus.

   

Adding a Snowflake account

1. On the sidebar, click the Snowflake Accounts icon.

   

2. Click Add Account on the top right to open a form.

3. Enter your Snowflake account name. To get the account name:

   1. Log in to Snowflake.

   2. Click the dropdown arrow next to the Snowflake icon on the bottom left and, in the open list, select the account you want to monitor.

   3. Click the copy icon next to the account.

   4. Enter the copied account in the form and replace . with -.

      For example, oalsots.ot18677 becomes oalsots-ot18677.

      You can get the current Snowflake account name from the address in your browser — the text immediately following the two forward slashes:

      

4. Enter a username, a password, and a warehouse name. You can use an existing user and warehouse or create new ones.

   • As an account user, you must have a default role with at least the permissions USAGE_VIEWER and GOVERNANCE_VIEWER on the Snowflake database. Learn more about creating a new user with the proper permissions using a script.

   • What you enter in the warehouse field will be the Snowflake warehouse used by Spendview for Snowflake. Your Snowflake user should have the correct privileges to use this warehouse. Learn more about creating a new warehouse using a script.

     We recommend you use an existing warehouse frequently used as the queries triggered by the platform are relatively small. They will not increase your expenses significantly if they run on a warehouse used by other users.

5. Click Submit to add the Snowflake account.

6. Repeat the above steps to add all the Snowflake accounts you want to monitor.

   

7. To switch to the account cost view, click the dollar sign on the top right of the tile.

   The cost per credit and Terrabyte (TB) are default values. Check these and change them if you're Snowflake billing is different.

8. Click Edit, modify the cost per credit and TB if needed, and click Save.