"""Loads data from an s3 bucket into a snowflake table."""
COPY_INTO_S3_AS_JSON = """
    COPY INTO 's3://{s3_bucket}/{s3_location}/{file_name}'
    FROM (
        SELECT array_agg(object_construct(*) ) WITHIN GROUP(ORDER BY ORCH_UPC asc, "VOLUME" asc, TRACK asc)
        FROM (
            SELECT *
		    FROM {source_snowflake_database}.{source_snowflake_schema}.{snowflake_table_name}
		    ORDER BY ORCH_UPC ASC, "VOLUME" ASC, TRACK ASC
		    LIMIT {limit}
		    OFFSET {offset}
        )
    )
    CREDENTIALS=(
        aws_key_id='{aws_key_id}'
        aws_secret_key='{aws_secret_id}'
    )
    FILE_FORMAT=(
        TYPE=JSON
        COMPRESSION=NONE
    )
;"""
# flake8: noqa