Unable to pass Multiple files to PROMPT()
I am trying to pass Multiple files as a visual context to Claude-sonnet 4.6 using Prompt and TO_File() function
but getting error even though I'm not hitting context limit and also each pdf is 3mb so the cap of 22mb is also well within the limit.
Verified the file location too.
weirdly it was working yesterday and today it is just not able to take multiple files
heres the code
SELECT AI_COMPLETE(
'claude-sonnet-4-6',
PROMPT(
'Summarize both documents and highlight any differences. DOCUMENT 1: {0} DOCUMENT 2: {1}',
TO_FILE('@"DB"."SPC"."LAMS"/folder OS Car _26.pdf'),
TO_FILE('@"DB"."SPC"."LAMS"/folder OS Bike _26.pdf'),
'how many documents are there, and mention the months'
)
) AS two_file_test;