Menu
What's the best data type to use for a column in a redshift table that will hold a very long string (can be up to 50KB)?
TEXT is replaced by varchar(256) by default. For now I used varchar(65535), but I'm not sure if that's the right way to do that...
Thanks
396
Amazon Redshift Numeric supports three kinds of Integer data types, SMALLINT, INT, and BIGINT.
Unstructured data – Data in Amazon Redshift must be structured by a defined schema, rather than supporting arbitrary schema structure for each row. If your data is unstructured, you can perform extract, transform, and load (ETL) on Amazon EMR to get the data ready for loading into Amazon Redshift.
VARCHAR(size) A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum string length in characters - can be from 0 to 65535. BINARY(size) Equal to CHAR(), but stores binary byte strings.
Text Data Type in Redshift:
For Redshift Text Data Type you can use varchar(max) or varchar(65535)
That is the maximum length of a text data type field in Redshift.
136
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
