"""Query to create a list of assets to ingest."""
CREATE_COVER_ASSET_INGESTION_FILE = """
    COPY INTO '@{source_snowflake_database}.{source_snowflake_schema}.{s3_stage_name}/{file_name}'
        FROM (
            SELECT
                {foreign_key_field} AS FOREIGN_REL_ID,
                DIGITAL_UPC AS ORCH_UPC,
                CONCAT({foreign_key_field}, '.jpg') as FILE_NAME,
                NULL AS UPLOAD_DATE,
                0 AS FILE_SIZE,
                ORCHLABELID AS VENDOR_ID,
                '{session_id}'as SESSION_ID
            FROM {source_snowflake_database}.{source_snowflake_schema}.{source_table_name}
        )
    OVERWRITE = TRUE
    HEADER = TRUE
    SINGLE = TRUE;
"""
# flake8: noqa