How to speed up Redshift queries

Question

I am using json_extract_path_text function to extract values from JSON. As row data increases, query takes long time to run and fails for some time.

Is there a way to reduce query execution time or improve josn_extract_path_text function

Answer 1

The solution is: store your data in tabular format instead of JSON. JSON is not a good choice for storing larger data sets because, by storing disparate data in a single column, JSON does not leverage Amazon Redshift’s column store architecture. Or alternatively change you node type to bigger one.