Cast data type

Can I cast a column to anther datatype, I had a column is EXPCURRENCY datatype, but I need cast to NUMBER datatype for formatting.

Hi @tomato
I guess you’re using SQL Server?
I’m not sure if it makes a difference if you change Field Type to “Number” in Admin > Data Model.
If that doesn’t work, then a database view is probably your best solution.

changes from the Admin -> Data Model has no effect. Can I cast it in native SQL, would that work?

@tomato Yes, you should be able to do that, and then you can use that question as the source for other questions via Saved Questions. But there’s several other limitations you might experience.

is there any plan to add it in as enhancement in future release?

@tomato
Have you tried to create a Custom Column, where you use formula like [column] * 1 - I’m not sure, since it depends on the database if it changes the column type (most likely to FLOAT)

I’ve tried create a Custom column, but not allow me to user the Cast function in the formula.

@tomato I know, that function doesn’t exists. What happens if you just use this:

[column] * 1

that works.

Hi, I run into error when drilling down the data from graph after using custom column with [column] * 1

:joins [{:strategy :inner-join, :source-table 3666, :condition [:= [:field-id 34446] [:joined-field “BLT_BILL_AMT” [:field-id 34680]]], :alias “BLT_BILL_AMT”}],
:filter
[:and
[:= [:datetime-field [:field-id 34409] :year] [:relative-datetime 0 :year]]
[:= [:field-id 34419] [:value “LA” {:base_type :type/Text, :special_type :type/Category, :database_type “varchar”}]]],
:expressions {:Total Bill Amount [:* [:field-id 34390] 1]},
:fields
[[:field-id 34446]
[:field-id 34427]
[:field-id 34400]
[:field-id 34385]
[:field-id 34431]
[:field-id 34392]
[:field-id 34437]
[:datetime-field [:field-id 34409] :default]
[:field-id 34417]
[:field-id 34416]
[:field-id 34395]
[:field-id 34402]
[:field-id 34412]
[:field-id 34386]
[:field-id 34430]
[:field-id 34380]
[:field-id 34396]
[:datetime-field [:field-id 34438] :default]
[:field-id 34407]
[:datetime-field [:field-id 34387] :default]
[:field-id 34434]
[:field-id 34436]
[:field-id 34442]
[:field-id 34439]
[:datetime-field [:field-id 34428] :default]
[:field-id 34432]
[:field-id 34388]
[:field-id 34443]
[:datetime-field [:field-id 34391] :default]
[:datetime-field [:field-id 34410] :default]
[:datetime-field [:field-id 34415] :default]
[:datetime-field [:field-id 34420] :default]
[:field-id 34404]
[:field-id 34422]
[:field-id 34414]
[:field-id 34444]
[:datetime-field [:field-id 34421] :default]
[:field-id 34405]
[:field-id 34419]
[:field-id 34413]
[:field-id 34435]
[:field-id 34398]
[:field-id 34448]
[:field-id 34440]
[:field-id 34383]
[:datetime-field [:field-id 34425] :default]
[:field-id 34433]
[:field-id 34393]
[:field-id 34389]
[:field-id 34418]
[:field-id 34399]
[:field-id 34406]
[:field-id 34379]
[:datetime-field [:field-id 34384] :default]
[:field-id 34447]
[:field-id 34424]
[:field-id 34381]
[:field-id 34382]
[:field-id 34445]
[:field-id 34394]
[:field-id 34408]
[:field-id 34411]
[:field-id 34429]
[:field-id 34426]
[:datetime-field [:field-id 34403] :default]
[:datetime-field [:field-id 34401] :default]
[:datetime-field [:field-id 34397] :default]
[:datetime-field [:field-id 34441] :default]
[:field-id 34390]
[:field-id 34423]
[:expression “Total Bill Amount”]
[:joined-field “BLT_BILL_AMT” [:field-id 34713]]
[:joined-field “BLT_BILL_AMT” [:field-id 34699]]
[:joined-field “BLT_BILL_AMT” [:field-id 34687]]
[:joined-field “BLT_BILL_AMT” [:field-id 34707]]
[:joined-field “BLT_BILL_AMT” [:field-id 34680]]
[:joined-field “BLT_BILL_AMT” [:field-id 34709]]
[:joined-field “BLT_BILL_AMT” [:field-id 34691]]
[:joined-field “BLT_BILL_AMT” [:field-id 34711]]
[:joined-field “BLT_BILL_AMT” [:field-id 34712]]
[:joined-field “BLT_BILL_AMT” [:field-id 34690]]
[:joined-field “BLT_BILL_AMT” [:field-id 34689]]
[:joined-field “BLT_BILL_AMT” [:field-id 34678]]
[:joined-field “BLT_BILL_AMT” [:field-id 34679]]
[:joined-field “BLT_BILL_AMT” [:field-id 34702]]
[:joined-field “BLT_BILL_AMT” [:field-id 34704]]
[:joined-field “BLT_BILL_AMT” [:field-id 34684]]
[:joined-field “BLT_BILL_AMT” [:field-id 34686]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34706]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34685]]
[:joined-field “BLT_BILL_AMT” [:field-id 34696]]
[:joined-field “BLT_BILL_AMT” [:field-id 34692]]
[:joined-field “BLT_BILL_AMT” [:field-id 34710]]
[:joined-field “BLT_BILL_AMT” [:field-id 34705]]
[:joined-field “BLT_BILL_AMT” [:field-id 34683]]
[:joined-field “BLT_BILL_AMT” [:field-id 34695]]
[:joined-field “BLT_BILL_AMT” [:field-id 34694]]
[:joined-field “BLT_BILL_AMT” [:field-id 34701]]
[:joined-field “BLT_BILL_AMT” [:field-id 34693]]
[:joined-field “BLT_BILL_AMT” [:field-id 34708]]
[:joined-field “BLT_BILL_AMT” [:field-id 34697]]
[:joined-field “BLT_BILL_AMT” [:field-id 34688]]
[:joined-field “BLT_BILL_AMT” [:field-id 34714]]
[:joined-field “BLT_BILL_AMT” [:field-id 34698]]
[:joined-field “BLT_BILL_AMT” [:field-id 34703]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34682]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34681]]
[:joined-field “BLT_BILL_AMT” [:field-id 34700]]],
:limit 2000}},
:native nil,
:ex-data {:type :schema.core/error, :value [nil “Total Bill Amount”], :error [(named (not (map? nil)) arg0) nil]}}

@tomato
Please post “Diagnostic Info” from Admin > Troubleshooting.
And the full stacktrace from Admin > Troubleshooting > Logs.

this is happening to all the custom columns.

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.core Starting Metabase in STANDALONE mode
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.core Starting Metabase version v0.34.3 (1a83edb release-0.34.x) …
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.core System info:
{“java.runtime.name” “Java™ SE Runtime Environment”,
“java.runtime.version” “1.8.0_211-b12”,
“java.vendor” “Oracle Corporation”,
“java.vendor.url” “http://java.oracle.com/”,
“java.version” “1.8.0_211”,
“java.vm.name” “Java HotSpot™ Client VM”,
“java.vm.version” “25.211-b12”,
“os.name” “Windows 10”,
“os.version” “10.0”,
“user.language” “en”,
“user.timezone” “America/Los_Angeles”}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:47-07:00 ERROR metabase.driver.sql.query-processor Invalid HoneySQL form:
{:from ((identifier :table “dbo” “BLT_BILL”)),
:select
([(identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field-alias “TRAN_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “ANNUAL_TYPE”) (identifier :field-alias “ANNUAL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “AUTH_REQD”) (identifier :field-alias “AUTH_REQD”)]
[(identifier :field “dbo” “BLT_BILL” “AUTHORIZED”) (identifier :field-alias “AUTHORIZED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_CODE”) (identifier :field-alias “BILL_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_REASON”) (identifier :field-alias “BILL_ADJ_REASON”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_CATEGORY”) (identifier :field-alias “BILL_CATEGORY”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_DATE”) (identifier :field-alias “BILL_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_NUM”) (identifier :field-alias “BILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_PRINTED”) (identifier :field-alias “BILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_TYPE”) (identifier :field-alias “BILL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “BILLGRP_UNO”) (identifier :field-alias “BILLGRP_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BL_EMPL_UNO”) (identifier :field-alias “BL_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BRAGO”) (identifier :field-alias “BRAGO”)]
[(identifier :field “dbo” “BLT_BILL” “COVER_NUM”) (identifier :field-alias “COVER_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “CURRENCY_CODE”) (identifier :field-alias “CURRENCY_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_BY_UNO”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_BY_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_DATE”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_NUM”) (identifier :field-alias “DELAYED_SPLIT_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “DESELECT_DATE”) (identifier :field-alias “DESELECT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DISB_ADJ_CODE”) (identifier :field-alias “DISB_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DISTRIBUTION_METHOD_PREBILL”) (identifier :field-alias “DISTRIBUTION_METHOD_PREBILL”)]
[(identifier :field “dbo” “BLT_BILL” “DRUNO”) (identifier :field-alias “DRUNO”)]
[(identifier :field “dbo” “BLT_BILL” “EB_INITIATED”) (identifier :field-alias “EB_INITIATED”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_DATE”) (identifier :field-alias “EDIT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_EMPL_UNO”) (identifier :field-alias “EDIT_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_STATUS”) (identifier :field-alias “EDIT_STATUS”)]
[(identifier :field “dbo” “BLT_BILL” “FIRM_REFERENCE”) (identifier :field-alias “FIRM_REFERENCE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DI_DATE”) (identifier :field-alias “FROM_DI_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DP_DATE”) (identifier :field-alias “FROM_DP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TP_DATE”) (identifier :field-alias “FROM_TP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TT_DATE”) (identifier :field-alias “FROM_TT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “INTBILL_SESSION”) (identifier :field-alias “INTBILL_SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “IS_DELAYED_SPLIT”) (identifier :field-alias “IS_DELAYED_SPLIT”)]
[(identifier :field “dbo” “BLT_BILL” “IS_RFP_BILL”) (identifier :field-alias “IS_RFP_BILL”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_BILL_ACTION”) (identifier :field-alias “LAST_BILL_ACTION”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_MODIFIED”) (identifier :field-alias “LAST_MODIFIED”)]
[(identifier :field “dbo” “BLT_BILL” “MANUAL_PREPARE”) (identifier :field-alias “MANUAL_PREPARE”)]
[(identifier :field “dbo” “BLT_BILL” “OFFC”) (identifier :field-alias “OFFC”)]
[(identifier :field “dbo” “BLT_BILL” “ORIG_NUM”) (identifier :field-alias “ORIG_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PB_ADMIN_EDITOR_UNO”) (identifier :field-alias “PB_ADMIN_EDITOR_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_BILLING_COORD_UNO”) (identifier :field-alias “PB_BILLING_COORD_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_CURRENT_STATUS_UNO”) (identifier :field-alias “PB_CURRENT_STATUS_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_LAUNCH_METHOD”) (identifier :field-alias “PB_MARKUP_LAUNCH_METHOD”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_WF_NAME”) (identifier :field-alias “PB_MARKUP_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PB_PRINT_DATE”) (identifier :field-alias “PB_PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “PB_RESP_TK_UNO”) (identifier :field-alias “PB_RESP_TK_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_REVIEW_APPROVAL_WF_NAME”) (identifier :field-alias “PB_REVIEW_APPROVAL_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PERIOD”) (identifier :field-alias “PERIOD”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_NUM”) (identifier :field-alias “PREBILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_PRINTED”) (identifier :field-alias “PREBILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “PRIMARY_REGION”) (identifier :field-alias “PRIMARY_REGION”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_CURRENCY”) (identifier :field-alias “PRINT_CURRENCY”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_DATE”) (identifier :field-alias “PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “RELEASED”) (identifier :field-alias “RELEASED”)]
[(identifier :field “dbo” “BLT_BILL” “RULE_EXCEPT”) (identifier :field-alias “RULE_EXCEPT”)]
[(identifier :field “dbo” “BLT_BILL” “SB_TYPE”) (identifier :field-alias “SB_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “SESSION”) (identifier :field-alias “SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “SPLIT_DETAIL”) (identifier :field-alias “SPLIT_DETAIL”)]
[(identifier :field “dbo” “BLT_BILL” “SPOT_RATE”) (identifier :field-alias “SPOT_RATE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_CODE”) (identifier :field-alias “TC_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_TOTAL_BILL_AMT”) (identifier :field-alias “TC_TOTAL_BILL_AMT”)]
[(identifier :field “dbo” “BLT_BILL” “TEXT_ID”) (identifier :field-alias “TEXT_ID”)]
[(identifier :field “dbo” “BLT_BILL” “TIME_ADJ_CODE”) (identifier :field-alias “TIME_ADJ_CODE”)]),
:where
[:and
[:=
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (identifier :field “dbo” “BLT_BILL” “BILL_DATE”)))
(hsql/call :cast (identifier :field “dbo” “BLT_BILL” “BILL_DATE”) {:s “date”}))
{:s “datetime”})
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (hsql/call :dateadd {:s “week”} -1 :%getdate)))
(hsql/call :cast (hsql/call :dateadd {:s “week”} -1 :%getdate) {:s “date”}))
{:s “datetime”})]
[:= (identifier :field “dbo” “BLT_BILL” “OFFC”) “LA”]],
:join ([(identifier :table “dbo” “BLT_BILL_AMT”) (identifier :table-alias “BLT_BILL_AMT”)] [:= (identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field “BLT_BILL_AMT” “BILL_TRAN_UNO”)]),
:modifiers [“TOP 2000”]}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:47-07:00 ERROR metabase.query-processor.middleware.mbql-to-native Error transforming MBQL query to native:
{:type :query,
:query
{:source-table 998,
:joins [{:strategy :inner-join, :source-table 3666, :condition [:= [:field-id 34446] [:joined-field “BLT_BILL_AMT” [:field-id 34680]]], :alias “BLT_BILL_AMT”}],
:filter
[:and
[:= [:datetime-field [:field-id 34409] :week] [:relative-datetime -1 :week]]
[:= [:field-id 34419] [:value “LA” {:base_type :type/Text, :special_type :type/Category, :database_type “varchar”}]]],
:expressions {:Total Bill Amount [:* [:field-id 34390] 1]},
:fields
[[:field-id 34446]
[:field-id 34427]
[:field-id 34400]
[:field-id 34385]
[:field-id 34431]
[:field-id 34392]
[:field-id 34437]
[:datetime-field [:field-id 34409] :default]
[:field-id 34417]
[:field-id 34416]
[:field-id 34395]
[:field-id 34402]
[:field-id 34412]
[:field-id 34386]
[:field-id 34430]
[:field-id 34380]
[:field-id 34396]
[:datetime-field [:field-id 34438] :default]
[:field-id 34407]
[:datetime-field [:field-id 34387] :default]
[:field-id 34434]
[:field-id 34436]
[:field-id 34442]
[:field-id 34439]
[:datetime-field [:field-id 34428] :default]
[:field-id 34432]
[:field-id 34388]
[:field-id 34443]
[:datetime-field [:field-id 34391] :default]
[:datetime-field [:field-id 34410] :default]
[:datetime-field [:field-id 34415] :default]
[:datetime-field [:field-id 34420] :default]
[:field-id 34404]
[:field-id 34422]
[:field-id 34414]
[:field-id 34444]
[:datetime-field [:field-id 34421] :default]
[:field-id 34405]
[:field-id 34419]
[:field-id 34413]
[:field-id 34435]
[:field-id 34398]
[:field-id 34448]
[:field-id 34440]
[:field-id 34383]
[:datetime-field [:field-id 34425] :default]
[:field-id 34433]
[:field-id 34393]
[:field-id 34389]
[:field-id 34418]
[:field-id 34399]
[:field-id 34406]
[:field-id 34379]
[:datetime-field [:field-id 34384] :default]
[:field-id 34447]
[:field-id 34424]
[:field-id 34381]
[:field-id 34382]
[:field-id 34445]
[:field-id 34394]
[:field-id 34408]
[:field-id 34411]
[:field-id 34429]
[:field-id 34426]
[:datetime-field [:field-id 34403] :default]
[:datetime-field [:field-id 34401] :default]
[:datetime-field [:field-id 34397] :default]
[:datetime-field [:field-id 34441] :default]
[:field-id 34390]
[:field-id 34423]
[:expression “Total Bill Amount”]
[:joined-field “BLT_BILL_AMT” [:field-id 34713]]
[:joined-field “BLT_BILL_AMT” [:field-id 34699]]
[:joined-field “BLT_BILL_AMT” [:field-id 34687]]
[:joined-field “BLT_BILL_AMT” [:field-id 34707]]
[:joined-field “BLT_BILL_AMT” [:field-id 34680]]
[:joined-field “BLT_BILL_AMT” [:field-id 34709]]
[:joined-field “BLT_BILL_AMT” [:field-id 34691]]
[:joined-field “BLT_BILL_AMT” [:field-id 34711]]
[:joined-field “BLT_BILL_AMT” [:field-id 34712]]
[:joined-field “BLT_BILL_AMT” [:field-id 34690]]
[:joined-field “BLT_BILL_AMT” [:field-id 34689]]
[:joined-field “BLT_BILL_AMT” [:field-id 34678]]
[:joined-field “BLT_BILL_AMT” [:field-id 34679]]
[:joined-field “BLT_BILL_AMT” [:field-id 34702]]
[:joined-field “BLT_BILL_AMT” [:field-id 34704]]
[:joined-field “BLT_BILL_AMT” [:field-id 34684]]
[:joined-field “BLT_BILL_AMT” [:field-id 34686]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34706]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34685]]
[:joined-field “BLT_BILL_AMT” [:field-id 34696]]
[:joined-field “BLT_BILL_AMT” [:field-id 34692]]
[:joined-field “BLT_BILL_AMT” [:field-id 34710]]
[:joined-field “BLT_BILL_AMT” [:field-id 34705]]
[:joined-field “BLT_BILL_AMT” [:field-id 34683]]
[:joined-field “BLT_BILL_AMT” [:field-id 34695]]
[:joined-field “BLT_BILL_AMT” [:field-id 34694]]
[:joined-field “BLT_BILL_AMT” [:field-id 34701]]
[:joined-field “BLT_BILL_AMT” [:field-id 34693]]
[:joined-field “BLT_BILL_AMT” [:field-id 34708]]
[:joined-field “BLT_BILL_AMT” [:field-id 34697]]
[:joined-field “BLT_BILL_AMT” [:field-id 34688]]
[:joined-field “BLT_BILL_AMT” [:field-id 34714]]
[:joined-field “BLT_BILL_AMT” [:field-id 34698]]
[:joined-field “BLT_BILL_AMT” [:field-id 34703]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34682]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34681]]
[:joined-field “BLT_BILL_AMT” [:field-id 34700]]],
:limit 2000},
:database 33,
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:nested? false,
:query-hash [-46, 66, 101, 70, -90, -98, 62, 28, 101, 95, 38, -68, -85, 16, -17, -27, 67, -15, 95, 31, -125, 95, 52, -45, 19, -84, 8, 39, 82, -41, -82, -88]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:48-07:00 ERROR metabase.driver.sql.query-processor Invalid HoneySQL form:
{:from ((identifier :table “dbo” “BLT_BILL”)),
:select
([(identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field-alias “TRAN_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “ANNUAL_TYPE”) (identifier :field-alias “ANNUAL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “AUTH_REQD”) (identifier :field-alias “AUTH_REQD”)]
[(identifier :field “dbo” “BLT_BILL” “AUTHORIZED”) (identifier :field-alias “AUTHORIZED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_CODE”) (identifier :field-alias “BILL_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_REASON”) (identifier :field-alias “BILL_ADJ_REASON”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_CATEGORY”) (identifier :field-alias “BILL_CATEGORY”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_DATE”) (identifier :field-alias “BILL_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_NUM”) (identifier :field-alias “BILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_PRINTED”) (identifier :field-alias “BILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_TYPE”) (identifier :field-alias “BILL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “BILLGRP_UNO”) (identifier :field-alias “BILLGRP_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BL_EMPL_UNO”) (identifier :field-alias “BL_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BRAGO”) (identifier :field-alias “BRAGO”)]
[(identifier :field “dbo” “BLT_BILL” “COVER_NUM”) (identifier :field-alias “COVER_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “CURRENCY_CODE”) (identifier :field-alias “CURRENCY_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_BY_UNO”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_BY_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_DATE”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_NUM”) (identifier :field-alias “DELAYED_SPLIT_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “DESELECT_DATE”) (identifier :field-alias “DESELECT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DISB_ADJ_CODE”) (identifier :field-alias “DISB_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DISTRIBUTION_METHOD_PREBILL”) (identifier :field-alias “DISTRIBUTION_METHOD_PREBILL”)]
[(identifier :field “dbo” “BLT_BILL” “DRUNO”) (identifier :field-alias “DRUNO”)]
[(identifier :field “dbo” “BLT_BILL” “EB_INITIATED”) (identifier :field-alias “EB_INITIATED”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_DATE”) (identifier :field-alias “EDIT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_EMPL_UNO”) (identifier :field-alias “EDIT_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_STATUS”) (identifier :field-alias “EDIT_STATUS”)]
[(identifier :field “dbo” “BLT_BILL” “FIRM_REFERENCE”) (identifier :field-alias “FIRM_REFERENCE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DI_DATE”) (identifier :field-alias “FROM_DI_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DP_DATE”) (identifier :field-alias “FROM_DP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TP_DATE”) (identifier :field-alias “FROM_TP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TT_DATE”) (identifier :field-alias “FROM_TT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “INTBILL_SESSION”) (identifier :field-alias “INTBILL_SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “IS_DELAYED_SPLIT”) (identifier :field-alias “IS_DELAYED_SPLIT”)]
[(identifier :field “dbo” “BLT_BILL” “IS_RFP_BILL”) (identifier :field-alias “IS_RFP_BILL”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_BILL_ACTION”) (identifier :field-alias “LAST_BILL_ACTION”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_MODIFIED”) (identifier :field-alias “LAST_MODIFIED”)]
[(identifier :field “dbo” “BLT_BILL” “MANUAL_PREPARE”) (identifier :field-alias “MANUAL_PREPARE”)]
[(identifier :field “dbo” “BLT_BILL” “OFFC”) (identifier :field-alias “OFFC”)]
[(identifier :field “dbo” “BLT_BILL” “ORIG_NUM”) (identifier :field-alias “ORIG_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PB_ADMIN_EDITOR_UNO”) (identifier :field-alias “PB_ADMIN_EDITOR_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_BILLING_COORD_UNO”) (identifier :field-alias “PB_BILLING_COORD_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_CURRENT_STATUS_UNO”) (identifier :field-alias “PB_CURRENT_STATUS_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_LAUNCH_METHOD”) (identifier :field-alias “PB_MARKUP_LAUNCH_METHOD”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_WF_NAME”) (identifier :field-alias “PB_MARKUP_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PB_PRINT_DATE”) (identifier :field-alias “PB_PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “PB_RESP_TK_UNO”) (identifier :field-alias “PB_RESP_TK_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_REVIEW_APPROVAL_WF_NAME”) (identifier :field-alias “PB_REVIEW_APPROVAL_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PERIOD”) (identifier :field-alias “PERIOD”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_NUM”) (identifier :field-alias “PREBILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_PRINTED”) (identifier :field-alias “PREBILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “PRIMARY_REGION”) (identifier :field-alias “PRIMARY_REGION”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_CURRENCY”) (identifier :field-alias “PRINT_CURRENCY”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_DATE”) (identifier :field-alias “PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “RELEASED”) (identifier :field-alias “RELEASED”)]
[(identifier :field “dbo” “BLT_BILL” “RULE_EXCEPT”) (identifier :field-alias “RULE_EXCEPT”)]
[(identifier :field “dbo” “BLT_BILL” “SB_TYPE”) (identifier :field-alias “SB_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “SESSION”) (identifier :field-alias “SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “SPLIT_DETAIL”) (identifier :field-alias “SPLIT_DETAIL”)]
[(identifier :field “dbo” “BLT_BILL” “SPOT_RATE”) (identifier :field-alias “SPOT_RATE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_CODE”) (identifier :field-alias “TC_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_TOTAL_BILL_AMT”) (identifier :field-alias “TC_TOTAL_BILL_AMT”)]
[(identifier :field “dbo” “BLT_BILL” “TEXT_ID”) (identifier :field-alias “TEXT_ID”)]
[(identifier :field “dbo” “BLT_BILL” “TIME_ADJ_CODE”) (identifier :field-alias “TIME_ADJ_CODE”)]),
:where
[:and
[:=
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (identifier :field “dbo” “BLT_BILL” “BILL_DATE”)))
(hsql/call :cast (identifier :field “dbo” “BLT_BILL” “BILL_DATE”) {:s “date”}))
{:s “datetime”})
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (hsql/call :dateadd {:s “week”} -1 :%getdate)))
(hsql/call :cast (hsql/call :dateadd {:s “week”} -1 :%getdate) {:s “date”}))
{:s “datetime”})]
[:= (identifier :field “dbo” “BLT_BILL” “OFFC”) “LA”]],
:join ([(identifier :table “dbo” “BLT_BILL_AMT”) (identifier :table-alias “BLT_BILL_AMT”)] [:= (identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field “BLT_BILL_AMT” “BILL_TRAN_UNO”)]),
:modifiers [“TOP 2000”]}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:48-07:00 WARN metabase.query-processor.middleware.process-userland-query Query failure {:status :failed,
:class clojure.lang.ExceptionInfo,
:error “Input to expression-with-name does not match schema: \n\n\t [(named (not (map? nil)) arg0) nil] \n\n”,
:stacktrace
("–> mbql.util$fn__24784$expression_with_name__24789.invoke(util.clj:503)"
“driver.sql.query_processor$fn__69701.invokeStatic(query_processor.clj:200)”
“driver.sql.query_processor$fn__69701.invoke(query_processor.clj:196)”
“driver.sql.query_processor$as.invokeStatic(query_processor.clj:415)”
“driver.sql.query_processor$as.invoke(query_processor.clj:395)”
“driver.sql.query_processor$fn__70031$iter__70033__70037$fn__70038$fn__70039.invoke(query_processor.clj:450)”
“driver.sql.query_processor$fn__70031$iter__70033__70037$fn__70038.invoke(query_processor.clj:449)”
“driver.sql.query_processor$format_honeysql.invokeStatic(query_processor.clj:656)”
“driver.sql.query_processor$format_honeysql.invoke(query_processor.clj:650)”
“driver.sql.query_processor$mbql__GT_native.invokeStatic(query_processor.clj:761)”
“driver.sql.query_processor$mbql__GT_native.invoke(query_processor.clj:756)”
“driver.sql$fn__71296.invokeStatic(sql.clj:36)”
“driver.sql$fn__71296.invoke(sql.clj:34)”
“query_processor.middleware.mbql_to_native$query__GT_native_form$fn__37448.invoke(mbql_to_native.clj:17)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invokeStatic(mbql_to_native.clj:16)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invoke(mbql_to_native.clj:11)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__37455.invoke(mbql_to_native.clj:36)”
“query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__40562.invoke(annotate.clj:541)”
“query_processor.middleware.annotate$add_column_info$fn__40468.invoke(annotate.clj:485)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__41503.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__43430.invoke(resolve_joins.clj:184)”
“query_processor.middleware.limit$limit$fn__42138.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46195.invoke(results_metadata.clj:87)”
“query_processor.middleware.format_rows$format_rows$fn__42126.invoke(format_rows.clj:76)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__38215.invoke(add_dimension_projections.clj:234)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38866.invoke(add_source_metadata.clj:107)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__43480.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__38703.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__41578.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__43094.invoke(resolve_driver.clj:22)”
“query_processor.middleware.store$initialize_store$fn__46220$fn__46221.invoke(store.clj:11)”
“query_processor.store$do_with_store.invokeStatic(store.clj:46)”
“query_processor.store$do_with_store.invoke(store.clj:40)”
“query_processor.middleware.store$initialize_store$fn__46220.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__37366.invoke(async.clj:23)”
“query_processor.middleware.async_wait$runnable$fn__40619.invoke(async_wait.clj:89)”),
:query
{:type “query”,
:query
{:source-table 998,
:joins [{:fields “all”, :strategy “inner-join”, :source-table 3666, :condition ["=" [“field-id” 34446] [“joined-field” “BLT_BILL_AMT” [“field-id” 34680]]], :alias “BLT_BILL_AMT”}],
:filter [“and” [“time-interval” [“field-id” 34409] -1 “week”] ["=" [“field-id” 34419] “LA”]],
:expressions {:Total Bill Amount ["" [“field-id” 34390] 1]}},
:parameters [],
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-46, 66, 101, 70, -90, -98, 62, 28, 101, 95, 38, -68, -85, 16, -17, -27, 67, -15, 95, 31, -125, 95, 52, -45, 19, -84, 8, 39, 82, -41, -82, -88]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:nested? false,
:query-hash [-46, 66, 101, 70, -90, -98, 62, 28, 101, 95, 38, -68, -85, 16, -17, -27, 67, -15, 95, 31, -125, 95, 52, -45, 19, -84, 8, 39, 82, -41, -82, -88]},
:preprocessing-level 1,
:database 33,
:query
{:source-table 998,
:joins [{:strategy :inner-join, :source-table 3666, :condition [:= [:field-id 34446] [:joined-field “BLT_BILL_AMT” [:field-id 34680]]], :alias “BLT_BILL_AMT”}],
:filter
[:and
[:= [:datetime-field [:field-id 34409] :week] [:relative-datetime -1 :week]]
[:= [:field-id 34419] [:value “LA” {:base_type :type/Text, :special_type :type/Category, :database_type “varchar”}]]],
:expressions {:Total Bill Amount [:
[:field-id 34390] 1]},
:fields
[[:field-id 34446]
[:field-id 34427]
[:field-id 34400]
[:field-id 34385]
[:field-id 34431]
[:field-id 34392]
[:field-id 34437]
[:datetime-field [:field-id 34409] :default]
[:field-id 34417]
[:field-id 34416]
[:field-id 34395]
[:field-id 34402]
[:field-id 34412]
[:field-id 34386]
[:field-id 34430]
[:field-id 34380]
[:field-id 34396]
[:datetime-field [:field-id 34438] :default]
[:field-id 34407]
[:datetime-field [:field-id 34387] :default]
[:field-id 34434]
[:field-id 34436]
[:field-id 34442]
[:field-id 34439]
[:datetime-field [:field-id 34428] :default]
[:field-id 34432]
[:field-id 34388]
[:field-id 34443]
[:datetime-field [:field-id 34391] :default]
[:datetime-field [:field-id 34410] :default]
[:datetime-field [:field-id 34415] :default]
[:datetime-field [:field-id 34420] :default]
[:field-id 34404]
[:field-id 34422]
[:field-id 34414]
[:field-id 34444]
[:datetime-field [:field-id 34421] :default]
[:field-id 34405]
[:field-id 34419]
[:field-id 34413]
[:field-id 34435]
[:field-id 34398]
[:field-id 34448]
[:field-id 34440]
[:field-id 34383]
[:datetime-field [:field-id 34425] :default]
[:field-id 34433]
[:field-id 34393]
[:field-id 34389]
[:field-id 34418]
[:field-id 34399]
[:field-id 34406]
[:field-id 34379]
[:datetime-field [:field-id 34384] :default]
[:field-id 34447]
[:field-id 34424]
[:field-id 34381]
[:field-id 34382]
[:field-id 34445]
[:field-id 34394]
[:field-id 34408]
[:field-id 34411]
[:field-id 34429]
[:field-id 34426]
[:datetime-field [:field-id 34403] :default]
[:datetime-field [:field-id 34401] :default]
[:datetime-field [:field-id 34397] :default]
[:datetime-field [:field-id 34441] :default]
[:field-id 34390]
[:field-id 34423]
[:expression “Total Bill Amount”]
[:joined-field “BLT_BILL_AMT” [:field-id 34713]]
[:joined-field “BLT_BILL_AMT” [:field-id 34699]]
[:joined-field “BLT_BILL_AMT” [:field-id 34687]]
[:joined-field “BLT_BILL_AMT” [:field-id 34707]]
[:joined-field “BLT_BILL_AMT” [:field-id 34680]]
[:joined-field “BLT_BILL_AMT” [:field-id 34709]]
[:joined-field “BLT_BILL_AMT” [:field-id 34691]]
[:joined-field “BLT_BILL_AMT” [:field-id 34711]]
[:joined-field “BLT_BILL_AMT” [:field-id 34712]]
[:joined-field “BLT_BILL_AMT” [:field-id 34690]]
[:joined-field “BLT_BILL_AMT” [:field-id 34689]]
[:joined-field “BLT_BILL_AMT” [:field-id 34678]]
[:joined-field “BLT_BILL_AMT” [:field-id 34679]]
[:joined-field “BLT_BILL_AMT” [:field-id 34702]]
[:joined-field “BLT_BILL_AMT” [:field-id 34704]]
[:joined-field “BLT_BILL_AMT” [:field-id 34684]]
[:joined-field “BLT_BILL_AMT” [:field-id 34686]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34706]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34685]]
[:joined-field “BLT_BILL_AMT” [:field-id 34696]]
[:joined-field “BLT_BILL_AMT” [:field-id 34692]]
[:joined-field “BLT_BILL_AMT” [:field-id 34710]]
[:joined-field “BLT_BILL_AMT” [:field-id 34705]]
[:joined-field “BLT_BILL_AMT” [:field-id 34683]]
[:joined-field “BLT_BILL_AMT” [:field-id 34695]]
[:joined-field “BLT_BILL_AMT” [:field-id 34694]]
[:joined-field “BLT_BILL_AMT” [:field-id 34701]]
[:joined-field “BLT_BILL_AMT” [:field-id 34693]]
[:joined-field “BLT_BILL_AMT” [:field-id 34708]]
[:joined-field “BLT_BILL_AMT” [:field-id 34697]]
[:joined-field “BLT_BILL_AMT” [:field-id 34688]]
[:joined-field “BLT_BILL_AMT” [:field-id 34714]]
[:joined-field “BLT_BILL_AMT” [:field-id 34698]]
[:joined-field “BLT_BILL_AMT” [:field-id 34703]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34682]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34681]]
[:joined-field “BLT_BILL_AMT” [:field-id 34700]]],
:limit 2000}},
:native nil,
:ex-data {:type :schema.core/error, :value [nil “Total Bill Amount”], :error [(named (not (map? nil)) arg0) nil]}}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:06-07:00 INFO metabase.sync.util STARTING: step ‘sync-fields’ for sqlserver Database 33 ‘ADR_Reporting’
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:06-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:06-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:11-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:11-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:14-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:14-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:16-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘HOURS’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:21-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:21-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:22-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/
.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:22-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘HOURS’ to a Field base_type, falling back to :type/*.

@tomato
I think you’re seeing this issue:
https://github.com/metabase/metabase/issues/11519 - upvote by clicking :+1: on the first post
In the future, please only post the relevant error and use the </> button in the forum comment box, so it’s formatted as code.

Is a bit different in my case than issues-11519, I didn’t change the column name in Metabase, just turn off the friendly name option.

Any plan to either fix the mapping “EXPCURRENCY” or fix the custom column issue?

@tomato There’s 2000+ other issues. Please open an issue for this. And if you provide a way to reproduce it, then chances of it getting fixed is much higher.