I have a .twbx dashboard pointing to a Cloudera Hadoop database. One of the columns on the database is a date/time that I convert to date in data extract. On the Hadoop database this column will be changing to a string in a production release in a few weeks.
My question is will the Tableau extract be able to switch from converting a date/time into a date field to switching a string into a date field without any changes from me?
I don't have control of either the Hadoop environment or the Tableau server environment where the dashboard is hosted (both of which are managed by different IT teams) and due to release schedules I can't line up a release of an updated datasource for the dashboard till two weeks after the Hadoop database will be updated. So I'm facing a potential two week gap where the dashboard will be unable to refresh unless Tableau extract can automatically react to the change. To reiterate again both production environments are outside of my control.
Thanks
Hi @Neil Mcquillan, could you try using Custom SQL to connect to the live table, and then either cast the impending date field to string.
And as a backup, keep the string to date cast handy too, just in case you do run into some problems.
cast(to_date(from_unixtime(unix_timestamp(STR_DMY, 'dd-MM-yyyy'))) as date)
Steve
