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, dbtLast 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 TechFull 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