Tableau seems to be auto casting some of the fields in my DB. Example (from log):
SELECT [Fund].[fund] AS [none:fund:nk],
SUM((CASE WHEN 10000 = 0 THEN NULL ELSE (CAST(((([SecurityMarketData].[eff_ddur] * [SecurityMarketData].[beta_ir]) * CAST([PMExposures].[rel_exposure_mult] as bigint)) * [PMExposures].[not_mv_weight]) as float) / 10000) END)) AS [sum:Rel Total KRD:qk]
I am looking to improve performance and would like to force it to not Cast. Any ideas?