Snowflake

Welcome to our Snowflake category. This section is dedicated to providing comprehensive resources, expert tutorials, and best practices for using Snowflake, the cloud data platform. Whether you’re a data analyst, data engineer, or IT professional, our content covers essential topics such as Snowflake architecture, data warehousing, performance optimization, data sharing, and security. Learn how to leverage Snowflake’s powerful features to streamline your data processes, improve scalability, and enhance your data analytics capabilities. Stay updated with the latest trends, tools, and techniques in Snowflake with our in-depth guides and practical insights.

Turquoise 3D Snowflake icon on a black background, illustrating how to identify Snowflake ACCOUNTADMIN privileges using Prismafy.

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake

By Deiby Gómez  Wondering how to quickly identify Snowflake ACCOUNTADMIN privileges and the users or roles that hold them? This article will show you how to easily identify them using Prismafy, a free tool that generates detailed reports in just a few minutes. Prismafy supports external authentication, usernames and passwords, and MFA, making it secure […]

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake Read More »

Databases, Security, Snowflake
Abstract geometric pattern symbolizing query profile changes in Snowflake. Detect query profile changes easily with Prismafy for better SQL query optimization.

How to Detect Query Profile Changes in Snowflake: Quick & Easy Method

By Deiby Gómez  In this article, we’ll explore how to quickly detect when Snowflake changes the way it executes your SQL statements. We’ll use the Prismafy tool for Snowflake, which generates detailed reports, allowing you to identify within minutes when a query profile changes. Prismafy is a free, open-source tool that supports external authentication, including

How to Detect Query Profile Changes in Snowflake: Quick & Easy Method Read More »

Databases, Snowflake, SQL
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

Snowflake Data Warehouse and AWS Lambda

Serverless computing is here to stay, and while the term “serverless” is a bit of a misnomer, the concept offers many benefits. Most notably, serverless computing allows developers to focus on writing code and not concern themselves with provisioning, configuring, or maintaining servers. One such example of serverless computing is AWS Lambda. Although there are

Snowflake Data Warehouse and AWS Lambda Read More »

AWS, Cloud Computing, Data Integration, Serverless Architecture, Snowflake, Snowflake Computing
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

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem

Did you miss Phil Goerdt and Mike Fuller‘s presentation about Cloud computing and storing data at MinneAnalytics #BIgDataTech last week? Let us share their presentation with you! Download it here! Cloud computing has changed how organizations use, access and store their data. While these paradigms have shifted, the traditional way of thinking about databases and data warehouses remain steadfast in

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem Read More »

Big Data, Cloud, Events, Snowflake

Modules of Knowledge

One of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available).

Modules of Knowledge Read More »

Big Data, ODI, Snowflake
Scroll to Top