UI doesn't display data types correctly for date types

[sherifnada]

Tell us about the problem you're trying to solve

The table of supported data types mentioned here is not correctly reflected on the UI.
For example see the schema definition below:

json_schema = {  # Example
            "$schema": "http://json-schema.org/draft-07/schema#",
            "type": "object",
            "properties": {
                "id": {"type": "number"},
                "created_at": {"type": "string", "format": "date-time", "airbyte_type": "timestamp_without_timezone"},
                "updated_at":{"type": "string", "format": "date-time", "airbyte_type": "timestamp_without_timezone"},
                "job": {"type": "string"},
                "company": {"type": "string"},
                "ssn": {"type": "string"},
                "residence": {"type": "string"},
                "current_location": {"type": "array", "items": "number"},
                "blood_group": {"type": "string"},
                "website": {"type": "array", "items": "string"},
                "username": {"type": "string"},
                "name": {"type": "string"},
                "sex": {"type": "string"},
                "address": {"type": "string"},
                "mail": {"type": "string"},
                "birthdate": {"type": "string", "format": "date"},
            },
        }

here is what's shown in the UI

The updated_at column, for example, should be shown as a timestamp with timezone as opposed to a string.

Describe the solution you’d like

Correctly display on the UI

cc @evantahler

[octavia-squidington-iii]

cc @airbytehq/frontend

[evantahler]

For reference, this was discovered while working on #11738

[grishick]

@krishnaglick I noticed that this is still not working correctly for database sources. For example, this field will show as string in the UI:

"event_timestamp":{"type":"string","format":"date-time","airbyte_type":"timestamp_with_timezone"}}}

[octavia-squidington-iii]

cc @airbytehq/frontend

[krishnaglick]

@krishnaglick I noticed that this is still not working correctly for database sources. For example, this field will show as string in the UI:

"event_timestamp":{"type":"string","format":"date-time","airbyte_type":"timestamp_with_timezone"}}}

The work hadn't been merged, unsure why this was marked as done. I just merged it, please check it out again!

[grishick]

@krishnaglick this issue was likely auto-closed when #11770 was merged:

is there another PR that is part of fixing this issue?

[krishnaglick]

#14671 is a cousin ticket I believe