Connecting to redshift DB through ODBC. Pulling several tables. Hit a snag with one table only. Getting this error message. Preview looks fine
The current version has a limit for the number of unique values per column (around 48 million). Version 4.5 won’t have it.
- If possible remove from the query columns with high cardinality (i.e. columns with many unique values)
- Use iterations to load and process data in partitions
Got it. Thanks!