This has already been reported and closed elsewhere
supabase/supabase#12539
The solution was to update documentation but I think, if possible, a better solution would be to add this to the runtime error message, as it's not easy or intuitive to find in the documentation, and if it was directly in the error message I would have easily avoided many hours of troubleshooting.