Constructing JSON directly within SQL queries (converting rows to JSON)


I need to construct a complex JSON which replicates the structure of API response using sql query, in order to compare both for testing purpose. Can/will redshift support JSON functions (such as json_build_object, rows_to_json, json_agg, array_to_json...) to build complex JSON queries. If not, is there any alternative?

asked 4 months ago320 views
1 Answer


So far, Redshift supports only these JSON functions. Also, OBJECT_TRANSFORM function could help. Please check if they satisfy your requirements.

profile picture
answered 4 months 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