Redshift column types being converted (UTC -> PT, BIGINT -> Double (float))
I'm having an issue with a specific datasource in Redshift converting columns of ID numbers from INTs to Double, thus making the "combine datasets" feature not work.
Additionally, in this specific data source, timestamps are being converted from UTC into PDT or MST. Since we store most times as UTC in our databases, this means that specific charts from specific data sources will report different times/dates/totals.
The underlying query is just a SELECT * FROM tablename;, which I created in the web interface.
It seems like the options are pretty simple, but is there some sort of configuration tool that I'm missing here that's making this happen selectively?