Explore the different datatype to catalog datatype mappings available for the Azure Cosmos DB datasource.
The tables lists the mapping from datatype to catalog datatype using advance connectivity bundle, making data management simpler and more organized.
| Datatype | Catalog datatype |
|---|---|
| boolean | boolean |
| date | date |
| date_date | date |
| date_day_of_month | integer |
| date_day_of_week | string |
| date_day_of_month | integer |
| date_day_of_week_index | integer |
| date_day_of_year | integer |
| date_fiscal_month_num | integer |
| date_fiscal_quarter | integer |
| date_fiscal_quarter_of_year | integer |
| date_fiscal_year | integer |
| date_hour | integer |
| date_hour_of_day | integer |
| date_microsecond | integer |
| date_millisecond | integer |
| date_minute | integer |
| date_month | integer |
| date_month_name | string |
| date_month_num | integer |
| date_quarter | integer |
| date_quarter_of_year | integer |
| date_raw | date |
| date_second | integer |
| date_time | datetime |
| date_time_of_day | datetime |
| date_week | integer |
| date_week_of_year | integer |
| date_year | integer |
| distance | decimal |
| duration | datetime |
| duration_day | integer |
| duration_hour | integer |
| duration_minute | integer |
| duration_month | integer |
| duration_quarter | integer |
| duration_second | integer |
| duration_week | integer |
| duration_year | integer |
| int | integer |
| location | string |
| number | decimal |
| string | string |
| tier | string |
| time | time |
| unquoted | integer |
| yes no | string |
| zipcode | string |
| date_hourX | integer |
| date_millisecondX | integer |
| date_minuteX | integer |
| time | time_with_timezone |
| datetime | timestamp |
| datetime | timestamp_with_timezone |