"""Query to create a list of assets to ingest."""
CREATE_AUDIO_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,
                VOLUME,
                TRACK_NO AS TRACK,
                FILE_NAME,
                NULL AS UPLOAD_DATE,
                0 AS FILE_SIZE,
                DIGITAL_UPC AS ORCH_UPC,
                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