"""Query to create a list of assets to ingest."""
CREATE_AUDIO_ASSET_INGESTION_TABLE = """
CREATE OR REPLACE TABLE {source_snowflake_database}.{source_snowflake_schema}.{target_table_name} as
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};
"""
# flake8: noqa