Add File Modification Time
Creates a new column containing the modification time of the file where each row originated from.
Example
name |
| John |
| Jane |
→
file_modification_time | name |
| 2022-08-09 12:01:57.000 | John |
| 2022-08-10 07:01:57.000 | Jane |
Configuration
Key Considerations
- For file sources, the transform uses the time when the file was added to the source.
- For all other sources, the transform uses the extraction finished time. This is the time when the extraction output was added to the intermediate bucket.