Redshift and TEXT Columns

Community Explorer

In loading our data to Redshift, there were a handful of tables with TEXT columns. Redshift internally converts these to VARCHAR(256) and I eventually set them to VARCHAR(MAX) but found that still wasn't enough for assignment_dim, discussion_entry_dim, discussion_topic_dim, submission_dim, and wiki_page_dim. I truncated the data to make it work for now, but I was just curious - how does Instructure handle these large TEXT columns in their hosted Redshift instances?