Using INSERT

In the world of data engineering, we must decide how we are going to add in new data as it comes into our platform. In this exercise, we will be practicing using the INSERT syntax to append new rows of data into our existing datasets.

In this scenario, imagine that we are responsible for keeping our claims systems up to date. Every day, we receive a new batch of claims that we need to append into our dataset.