Redshift and TEXT Columns
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2017
04:10 PM
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?
Thanks,
Jeff
