AWS Tutorials - Handling JSON Data in Amazon Redshift

The SQL script URL - aws-dojo.com/v...
Amazon Redshift supports semistructured data. Using the SUPER data type and PartiQL language, Amazon Redshift expands data warehouse capability to integrate with both SQL and NoSQL data sources. It enables user to analyze both relational and semistructured data such as JSON in Redshift database.

[@karinaillesova]

This is very informative. Thank you!

[@markthomas9641]

Great video, thank you. DeltaJSON is really useful for devops working with JSON in AWS, it does compare, merge and graft via API service.

[@AWSTutorialsOnline]

Thanks for sharing!

[@basedsonu]

Is that a cross join in the query "from customers, orders"?

[@RameshKumar-cx8rz]

I think super column has 16 MB size but not 1 MB as you said in this video. Correct me?

[@Pandatpandtani]

what is the performance impact on searching a field inside json datatype as compare to normal field??

[@Mustafa-yk8lk]

ithink the best practice use case for using RD spectrum to load data into RD is when we have data stored in parquet format in s3 !

[@AWSTutorialsOnline]

You don't need to load data to RS if you have access to data using Spectrum. Parquet format gives opportunity for optimized data scan.

[@nicholastucci728]

Thanks for your video, very informative as always! I have a question though, in my case fields of my JSON column are camel case, for example I have something like `FirstName` or `LastName`. Now when I try to access them I get a null result instead. So if I try to ingest it lower casing it (e.g. lower() function) so I then have `firstname` or `lastname`, then I can query those fields. But still I'd like to keep those fields as in source, so Camel Cased, do you know if there is any workaround that?

[@AWSTutorialsOnline]

Please share json with me. I will check it at my end.