ETL refers to "Extract, Transform, and Load". By this point, the concept of ETL is well-established within the data industry and there are a number of enterprise-proven "ETL Tools" available to assist organizations with the movement and transformation of data. An ETL Tool is simply software that's designed to help organizations move and transform data [...]
Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1. Databricks is a managed Spark-based service for working with data in a cluster Databricks is an enhanced version of Spark and is touted by the Databricks [...]
ETL Best Practices and Techniques ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the [...]
We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and we’ve been integrating data through ETL techniques for decades now. However, what is new is the growing cloud offerings organizations are using and have access to today. For the Modern Enterprise, it’s common now [...]
60% of any analytics project lies in data integration. With the introduction of cloud solutions, there is now even more confusion around ingestion, ELT, ETL, curation, wrangling, and any other “term of the day” that is introduced. Gone are the days of heavy ETL solutions. On deck are agile solutions that lend to speed [...]
I’m incredibly excited to be a part of SQL Saturday Denver 673 both as a speaker and co-organizer. I will be co-presenting Two Guys and a Transformation: ETL Best Practices and Techniques with Gabe Villa where we’ll be sharing many of our lessons learned from decades of developing ETL solutions. We’ll cover core areas of [...]