Databases Archives - Red Pill Analytics

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

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

Cluttered garage representing the need to drop undead DBT-created tables for better database management.

Clear the Clutter! Find and Drop Undead dbt-Created Tables

by Alyssa Kunau Photo by todd kent on Unsplash Clutter- What is it? Where did it come from? In this guide, I’ll show you how to find and drop undead DBT-created tables to clear clutter. By “db clutter” I mean unnecessary, unused objects living in your database. There’s gonna be some word clutter here. In this post I’m

Clear the Clutter! Find and Drop Undead dbt-Created Tables Read More »

data cleaning, Databases, dbt

How to Use the New R ODBC Package to Connect to an Oracle Database

Last month a new R package was released called ODBC to improve the ability to connect to relational databases. By using these universal connection packages such as DBI and ODBC, you’ll be able to easily port your code to different databases. If you currently use RODBC to connect to Oracle, you’ll like ODBC more! ODBC

How to Use the New R ODBC Package to Connect to an Oracle Database Read More »

Databases, R, Women In Tech

BI Developer + Snowflake Root Access: A Love Story

Full Disclosure: I’ll be the first to tell you I’m not a DBA. I have a working knowledge of databases and “mainstream” SQL statements. I’m usually content to stay in my area of expertise and just query the data, make sure that the data is correct, and build some great content for clients. If you

BI Developer + Snowflake Root Access: A Love Story Read More »

Customer Service, Databases, Snowflake, SQL