Documentation

How to work with dates when uploading Flat Data files

Updated on

Jan 30, 2024

Date as a date-key

The Date column is a unique date-key in the database and must be singular. The Date column is needed if you want to use update logic that utilizes date-key (i.e. Incremental update logic).

To optimize data processing and ensure alignment with our internal systems, Improvado platform prioritizes columns named Date for identifying unique date-key. To ensure clarity and avoid any unintentional use of existing Date columns, we recommend renaming them to a more specific name within your spreadsheet context.

Update logic

  • Incremental (with date-key). Records get modified, and the old data is saved. Already existing rows get determined based on the set of dimensions in a Flat Data file and only rows that were changed are updated. Updated rows are not counted for your row count usage.
  • Snapshot (without date-key). All data is overwritten each time. We will automatically add an internal date-key column called date for any files missing a date-key column with today's date.

Flexibility in date formats

We offer a wide range of date formats for the Date column, allowing you to choose the one that best matches your existing setup.

You can also see the full list of supported date formats: {%dropdown-button name="destination" %}

{%dropdown-body name="destination" %}

  • ```MM/DD/YYYY```
  • ```DD/MM/YYYY```
  • ```YYYY/MM/DD```
  • ```MM-DD-YYYY```
  • ```DD-MM-YYYY```
  • ```YYYY-MM-DD```
  • ```MM.DD.YYYY```
  • ```DD.MM.YYYY```
  • ```YYYY.MM.DD```
  • ```MMDDYYYY```
  • ```DDMMYYYY```
  • ```YYYYMMDD```
  • ```DD Month, YYYY```
  • ```Month DD, YYYY```
  • ```YYYY, Month DD```
  • ```YYYY-MM-DD HH:MM:SS;SSS```

{%dropdown-end%}

Note: The date format you select from the dropdown indicates the date format in that column of your spreadsheet and helps us correctly parse dates in that column. But it is not the date format that will be stored in Improvado.

If the date format in your Flat Data files is missing from the list, you can create a new request using the Improvado Service Desk.

Avoid using system default names

Our system automatically adds default columns like ```id```, ```account_id```, ```account_name```, ```date``` and ```date_yyyymmdd```. Please avoid importing columns with these names to prevent data conflicts.

Schema information

Setup guide

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
How to work with dates when uploading Flat Data files
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.