Exporting data to S3 as JSON

Here is an example SQL statement to export data from Direct Access to S3

COPY INTO 's3://yours3bucket/path'
FROM (SELECT OBJECT_CONSTRUCT(*)
      from localytics_applications)
  CREDENTIALS = (AWS_KEY_ID = 'yourawskey' AWS_SECRET_KEY = 'yourawssecret')
  FILE_FORMAT = (TYPE=JSON);