Airbyte S3 Source Setup: Need to set datetime data type for columns in JSON SCHEMA

[sunila96]

Hi everyone, I am working on airbyte where I created an S3 source and I have to pull data into redshift, my requirements are to pull data into redshift following the same datatypes. In my S3 files, I have date values which need to be pulled in the same format but JSON Schema does not have a date type. Is there an alternate datatype that can be used here?

[jdesrosiers]

JSON Schema can only describe JSON type, which doesn't include dates. Types that aren't supported by JSON are typically represented as strings and further classified using the format keyword.

{
  "type": "string",
  "format": "date"
}

In the category of dates, JSON Schema defines "date", "time", "date-time", and "duration".