Data Liftoff

Data Liftoff

Skip to content
Menu
  • About Data Liftoff
  • Blog
  • Email List
  • Privacy Policy

Tag: data warehouse

Data EngineeringPosted onDecember 21, 2020December 21, 2020

The Year in Data and Analytics – 2020

Deep breath. In and out. I’ve been doing a lot of that in 2020, and I know I’m not alone. I hesitated to write a…

Read More
snowflake logo
Data EngineeringPosted onNovember 15, 2020November 15, 2020

Loading Data from S3 to into Snowflake

Loading data that’s been stored in an S3 bucket into a Snowflake data warehouse is an incredibly common task for a data engineer. In an…

Read More
blocks
Data EngineeringPosted onNovember 14, 2019November 15, 2019

Modular ELT

A while back, I wrote a post on why ELT is preferable to ETL with Amazon Redshift and other modern data warehouses such as Snowflake…

Read More
Data EngineeringPosted onAugust 15, 2019December 9, 2019

Unloading Data from Redshift to S3

In a previous post, I wrote about using the COPY command to load data from an S3 bucket into a Redshift table. In this post,…

Read More
Data EngineeringPosted onJuly 22, 2019December 12, 2019

Making Sense of Amazon Redshift Pricing

Considering building a data warehouse in Amazon Redshift? It’s a great option, even in an increasingly crowded market of cloud data warehouse platforms. If you’re…

Read More
Data Liftoff logo
Data WarehousingPosted onJuly 20, 2019August 25, 2019

Using Temp Tables for Staging Data Changes in Redshift

When you’re loading and transforming data in your Redshift data warehouse, you’ll often want to stage data in a temporary table rather than insert it…

Read More
Data EngineeringPosted onJune 23, 2019June 7, 2020

Data Warehouse vs Data Lake – What’s the Difference?

Data warehouses have been around for decades, but in the last few years you’ve probably heard the term “data lake”. Despite what some believe, a…

Read More
Data EngineeringPosted onJune 20, 2019July 20, 2019

How to Load Data from MongoDB into Amazon Redshift

MongoDB continues to be a major player in the unstructured data-space, and thus data engineers often confront the challenge of helping organizations make sense of…

Read More
Data EngineeringPosted onMay 10, 2019May 10, 2019

IAM Roles for Loading Data From S3 into Redshift

If you’re using Amazon Redshift, you’re likely loading in high volumes of data on a regular basis. The most efficient, and common, way to get…

Read More
Data EngineeringPosted onMay 2, 2019June 7, 2020

ELT with Amazon Redshift – An Overview

If you’ve been in Data Engineering, or what we once referred to as Business Intelligence, for more than a few years you’ve probably spent time…

Read More

Categories

  • Announcements
  • Collections
  • Data Analysis
  • Data Engineering
  • Data Science
  • Data Warehousing
  • Leadership
  • Machine Learning
  • Remote Work
  • Uncategorized
  • Working Better

Recent Posts

  • The Year in Data and Analytics – 2020
  • What is Apache Airflow? An Overview
  • Free Books and Courses for Data Analysts
  • Loading Data from S3 to into Snowflake
  • Taking Work Seriously, Not Personally

Follow Us

  • LinkedIn
  • Twitter
© Copyright 2021 – Data Liftoff
Allium Theme by TemplateLens ⋅ Powered by WordPress