Get Started

Data Warehousing

Welcome to our Data Warehousing category. This section is dedicated to providing in-depth resources, expert tutorials, and best practices on data warehousing. Whether you are a data architect, database administrator, or business intelligence professional, our articles cover essential topics such as data warehouse design, ETL processes, data integration, and performance optimization. Discover the latest trends and technologies in data warehousing and learn how to build robust and scalable data storage solutions to support your organization’s analytics needs.

Hand holding a rolled-up 20-dollar bill, symbolizing cost management in Snowflake credit consumption

How to Analyze Snowflake Credit Consumption for Cost Management

By Deiby Gómez Cloud-based data warehousing platforms like Snowflake have changed the way organizations store, manage, and analyze their data. But with this power and flexibility comes the challenge of managing costs, especially when it comes to Snowflake credit consumption. Snowflake’s pricing model can lead to unexpected expenses if credit usage is not monitored and […]

How to Analyze Snowflake Credit Consumption for Cost Management Read More »

Cloud Computing, Cost Management, Data Warehousing, Snowflake

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
A sleek, modern image showcasing a geometric prism illuminated by blue and red light, representing the precision and efficiency of data warehousing platforms like Snowflake. This visual highlights the importance of optimizing query performance, an essential step for consultants using tools such as Prismafy to diagnose and resolve performance bottlenecks.

The Definitive Guide to Analyzing Queries in Snowflake

By Deiby Gómez Snowflake is a top choice for data warehousing and cloud analytics, thanks to its exceptional scalability and performance. However, like any complex system, it isn’t immune to challenges. Performance issues, such as slow queries or overloaded warehouses, can disrupt data operations. The key to maintaining optimal performance is addressing these issues quickly.

The Definitive Guide to Analyzing Queries in Snowflake Read More »

Data Warehousing, Prismafy, Snowflake, SQL, Uncategorized

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
Abstract image of lasers criss-crossing above internal computer hardware.

Securing Network Access for Snowflake Data Warehouse and Amazon S3

As technology moves further into a service-oriented (read: Cloud) world, people and enterprises alike need to ensure that securing their assets is taken seriously. Security has always been one of the first of topics covered before purchasing a cloud service which is why good cloud vendors typically spend more time securing their products than any

Securing Network Access for Snowflake Data Warehouse and Amazon S3 Read More »

AWS, Code, Data Integration, Data Warehousing, Security, Snowflake
Scroll to Top