"""Copy an asset table to a JSON document."""
COPY_TABLE_TO_JSON = """
COPY INTO 's3://{bucket}/{prefix}/{key}'
FROM (
    SELECT array_agg(object_construct(*)) WITHIN GROUP (ORDER BY ORCH_UPC asc, "VOLUME" asc, TRACK asc)
    FROM (
        SELECT *
        FROM {catalog}.{schema}.{table_name}
        ORDER BY ORCH_UPC ASC, VOLUME ASC, TRACK ASC
  )
)
CREDENTIALS = (
    aws_key_id='{aws_key_id}'
    aws_secret_key='{aws_secret_key}'
  )
FILE_FORMAT = (
    TYPE=JSON
    COMPRESSION=NONE
 )
 OVERWRITE=TRUE
;
"""  # noqa