1. From the Dremio home screen hover over the NYC_Taxi Dataset and click on the edit button. This will allow you to edit an already existing VDS.

  2. Notice the fields pickup_datetime & dropoff_datetime include both the date and time as one value. For the purposes of this lab, we just need to keep the date.

  3. Dremio provides different ways to separate and remove values from a specific field. For the purposes of this lab, we are going to convert the data type from a Date & Time field to a Date field. Click the dropdown arrow next to the pickup_datetime field and select “Convert Data Type”.
  4. Under Select Type, select Date and press Apply. Notice that Dremio replaced the old field with the new field.
  5. Apply the same process to the dropoff_datetime field and press apply. After you are done your dataset should look like the screenshot below. Notice both pickup_datetime & dropoff_datetime now only include the date.
  6. Now that we have removed time, we need to rename the field. Click the dropdown arrow next to the pickup_datetime field and select Rename. Rename the field pickup_date.
  7. Apply the same process for the dropoff_datetime field.
  8. Save your edited dataset by clicking on the icon and selecting Save