[ARCHIVED] 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
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.