clickhouse-tableau-connector-jdbc icon indicating copy to clipboard operation
clickhouse-tableau-connector-jdbc copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

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

Open vlauzeckas opened this issue 2 years ago • 10 comments

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.

image

vlauzeckas avatar Aug 23 '22 16:08 vlauzeckas