Performance Optimization Archives

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste

By Deiby Gómez In this article, we’ll explore how to analyze the load and usage of a Snowflake warehouse to uncover opportunities for reducing credit waste and identifying overloaded warehouses. We’ll use the Prismafy tool, which generates detailed reports in just a few minutes. Prismafy is free to use and supports external authentication, including username/password […]

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste Read More »

Data Analytics, Data Warehousing, Snowflake, Snowflake Computing

Coin-operated binoculars facing a foggy seascape, symbolizing the exploration of data visibility with Looker.

Managing Snowflake Data Warehouse Compute in Looker

In a recent blog titled Managing Snowflake Data Warehouse Compute in OBIEE, I explained how to assign application users and roles to use designated compute clusters (warehouses) in Snowflake. The idea of specifying a Snowflake warehouse on a per user (or groups of users) basis is not specific to OBIEE and can be achieved with

Managing Snowflake Data Warehouse Compute in Looker Read More »

Business Intelligence, Cloud Computing, Data Warehousing

Managing Snowflake Data Warehouse Compute in OBIEE

How to Dynamically Set a Snowflake Virtual Warehouse Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouse instance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in

Managing Snowflake Data Warehouse Compute in OBIEE Read More »

Business Intelligence, Cloud Computing, Data Warehousing, Looker, Snowflake