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?
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board