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?
Solution
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.
- Connecting Palantir to Salesforce - how do you access the data tables (the SObjects)?
- Is that possible to create a custom input widget in Foundry Slate?
- formating text to a new field in foundry contour
- Automatically updating a dataset on Palantir Foundry when any of the immediate upstream resources updates
- Saving CSV files in Foundry Transforms
- Can I access directories in Palantir and use FOR to get names of all tables inside folder?
- How to make a working cycle for files in Palantir?
- In Foundry, how to read "added" rows in output since the last built?
- In Foundry, how to read entire current output dataset which has snaphot transaction type?
- Foundry Slate text box layout
- How to read entire data of output_df in Foundry Code repository?
- Rest API: Is there any endpoint that provides dataset lineage info?
- How to publish a Spark ML pyspark.ml.PipelineModel object in code repositories?
- Can I export .csv (in Gzip) from Palantir but only the first part has headers?
- How can I save filter and variable statuses in Workshop?
- How do you avoid sorting when writing partitioned data in Spark on Palantir Foundry?
- How to delete a file from dataset view in Foundry?
- Refresh platform data in tables after action
- Is it Possibility to change font type in the Workshop module?
- Optimal Data Sync Strategy for Palantir Foundry: Handling Incremental Updates Based on Timestamps
- Importing RIDs from a dataset with column RIDs with Palantir Foundry Code Repository
- Palantir Foundry - How to load PDF files from Compass folder into code repository transform
- Hide tabs in workshop module
- What object types are avaliable for export on <hostname>/phonograph2-export/api/?
- Using a Code Repo to call a Webhook created in Palantir Foundry
- Delete all rows with duplicate values in column in Palantir Foundry Countor
- Palantir Foundry - Making http request and capturing JSON response
- Pass a whole dataset contains multiple files to HuggingFace function in Palantir
- Is there any way to create a generic typescript function that works in different places with two different objects?
- Reference Workshop App Input Widget Value Externally (in a backend process e.g. Python Transform)