0

I am using the AWS RedShift serverless to query some s3 files which contain Parquet data. Before querying the data, I always need to run the following command:

SET json_serialization_enable TO true;

Is there a way to set this flag as true globally so that it is not tied to a session?

IamAshay
  • 1,377
  • 1
  • 7
  • 16

1 Answers1

2

You could set this using ALTER USER:

ALTER USER yourusername SET json_serialization_enable TO true;

This is similar to this answer: How to change default value for parameter globally for redshift cluster

Jacob Flanagan
  • 36
  • 3