Trying to concatenate two BIGINT keys to support an incremental extract refresh in Tableau. Using CAST AS NUMERIC(38,19), which works fine in Dremio SQL Editor, but is rounding to 4 digits past decimal in Tableau.
Also tried to_number, but that function drops trailing zeroes.
Any help is greatly appreciated.
Using Windows 64Bit Driver 1.4.2.1003