- 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.
- 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.
- 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”.
- Under Select Type, select Date and press Apply. Notice that Dremio replaced the old field with the new field.
- 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.
- 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.
- Apply the same process for the dropoff_datetime field.
- Save your edited dataset by clicking on the icon and selecting Save