How do I create a Palantir Foundry Fusion sync for a timestamp column?

I want to create a Fusion-backed dataset in Foundry. Usually, I would create the columns and set the types but when I add a timestamp column it turns up as null in the dataset:

How do I add a timestamp column to a Fusion table and sync it to a dataset correctly?

For timestamps, you should use the format:

YYYY-MM-DD HH:mm:ss

For example:

2022-08-30 11:09:39

This will result in the dataset sync completing successfully.

You can check the valid formats by setting the cell data type to timestamp, and hovering over the ? icon. This will also highlight the cell with a red underline if it does not match the expected format.