By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Loading json string data as super from Glue job in to Redshift

0

We're inserting a json string, in the Glue catalogue as string, from a Glue job in to Redshift using write_dynamic_frame_from_jdbc_conf.

We'd like to use the super data type to query the nested json data and I was wondering how it would be possible from the glue job to set the column as super or alter the varchar column once its in Redshift?

Topics
Analytics
Tags
AWS GlueAmazon Redshift
Language
English
Guy Jarvis
asked 2 years ago1074 views
1 Answer
0

I don't think AWS Glue supports the Redshift super native data type at this time. https://docs.aws.amazon.com/databrew/latest/dg/datatypes.html

AWS
asser_m
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content