Attempting to create column with too many rows

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.

Possible workarounds:

  • 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!