Your task is to perform a two-step data migration:
- Add a new column named acquired_at to the machine table. This column should be of the DATE data type.
- Update all records in the machine table:
- Populate the newly created acquired_at column by extracting the date value from the acquired field within the details JSON column.
- After successful extraction, remove the acquired field from the details JSON column.
Expected result
| ident | name | details | acquired_at |
|---|
Write your query below and click "Check it!". Tables are described in the right pane.
The query result will appear here. Ctrl+Enter - Run query