Summary
User inquires about setting field data types to ‘date’ or ‘datetime’ in the Connector Builder UI, encountering an error despite the string being formatted as yyyy-mm-dd.
Question
this feels like a very basic question, but is there a way to set a field data type as date or datetime in the Connector Builder UI? i get the error below.
the string is already formatted as yyyy-mm-dd, and i’d like to avoid an extra transformation step for a simple type casting
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
['field-data-type', 'date', 'datetime', 'connector-builder', 'type-casting']
yeah it’s definitely complaining at me, but that’s ok 
<@U04FJKLLDC6> hey do you want to set any of the user input field type to date or date type via connector builder ui? if so then its doable just edit the user input and change it to date or datetime.
nice! but no, i mean storing one of the output columns as a date (or datetime). is that possible? the schema validation seems to suggest otherwise
<@U04FJKLLDC6>
https://docs.airbyte.com/understanding-airbyte/supported-data-types
{"type": "string", "format": "date"}
{"type": "string", "format": "date-time"}
niiiiice, thanks so much!!
that did the trick. had been looking for this for so long. appreciate it, <@U05JENRCF7C>!
The only downside is that Builder right now treats schenas as either “automatically infer” or “manually”. Meaning if you setup manual schemas, and then your API schema changes and you want to refresh it, you’d have to toggle it back to automatic and it would overwrite your changes.
It’s a known limitation for a bit, but we haven’t yet gotten to make Builder schema designer work as “these fields are overriden, but the rest of the schema should be inferred automatically”.
yeah it’s definitely complaining at me, but that’s ok