Is the new JsonField supported?

[dkarchmer]

Since like Redshift does have support for Json fields, but I am unclear if django-redshift will translate the new JsonField to that.

[emyller]

@dkarchmer Unfortunately, Redshift doesn't support the JSON data type. It does provide a few functions to ease accessing data from JSON strings, but it doesn't leverage PostgreSQL's underlying capabilities.

From the Redshift documentation page linked above:

We recommend using JSON sparingly. JSON is not a good choice for storing larger datasets because, by storing disparate data in a single column, JSON does not leverage Amazon Redshift’s column store architecture.

However, I do store JSON on Redshift. In order to make the usage smoother with Django, I'm using @dmkoch's django-jsonfield to define model fields. Keep in mind though that the underlying varchar column is limited to 64KB-1 size, so one might want to store large JSON data somewhere else (e.g S3).