DateTime('UTC') is not recognized as timestamp in Tableau

[vlauzeckas]

Not sure it issue with the connector or JDBC driver itself, but i noticed strange behavior:

Add such query as custom SQL:
select toDateTime('2022-08-23 02:52:53') as tz, toTypeName(tz) as tz_type, toDateTime('2022-08-23 02:52:53', 'UTC') as tz_utc, toTypeName(tz_utc) as tz_utc_type

tz_utc - is not recognized as Timesstamp in tableau. You can change it on tableau level, but that would add huge overhead of casting string to datetime.

[yurifal]

hi @vlauzeckas
it looks like Tableau doesn't read the timezone Metadata from the [tz_utc] column,
so it couldn't recognise the data type "DateTime with timezone"
(it would return NULL as evident in Describe).

[vlauzeckas]

but thats a bit of a problem. if data type "DateTime with timezone" tableau does not recognize. you can force it to cast, but that's big overhead and lead to not optimal queries.

[yurifal]

I understand, but have neither a fix nor a workaround (other than obvious CASTing), sorry.

[gonchik]

@yurifal how does it works previously? :)
We met after upgrading driver and platform Tableau.

@vlauzeckas did you met after upgrade driver or after upgrading Tableau?
It so, maybe we have to together escalate to the Tableau ? :)

[yurifal]

@gonchik how does it works previously? :)
it doesn't work (and it had not been working as far as I'm aware of).

[gonchik]

@yurifal Noted, let me push back the BI team :)
Thanks for the fast response

[yurifal]

@gonchik you're welcome.

[vlauzeckas]

@yurifal how does it works previously? :) We met after upgrading driver and platform Tableau.

@vlauzeckas did you met after upgrade driver or after upgrading Tableau? It so, maybe we have to together escalate to the Tableau ? :)

Sorry, where did i mentioned upgrade?:)

[gonchik]

@vlauzeckas it's my mistake, it's a pity that I failed the exam in clairvoyance.
I found that one after upgrades that's why I have asked

[silentsokolov]

Any news? The same problem

Tableau Desktop v2023.3.x (and WebView on Server v2023.3.x)
ClickHouse v23.8.2.7
clickhouse-tableau-connector-jdbc v0.2.6
Clickhouse JDBC driver: 0.6.0