Explore the different datatype to catalog datatype mappings available for the Databricks datasource.
- Databricks: The table below lists the field‑level datatype to catalog
datatype mapping for the Databricks datasource.
Table 1. Datatype Catalog datatype array string bigint integer binary blob boolean boolean char string date date decimal decimal double double double precision double float double int integer map string numeric decimal smallint integer string string struct string timestamp timestamp tinyint integer union string varchar string
- Databricks Notebook: The tables lists the mapping from datatype to catalog
datatype for Databricks Notebook datasource.
Table 2. Datatype Catalog datatype undefined string date date date_date date date_day_of_month integer date_day_of_week string 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 yesno string zipcode string date_hourX integer date_millisecondX integer date_minuteX integer