Jeff Longland

Redshift and TEXT Columns

Discussion created by Jeff Longland on Nov 23, 2017

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?