How can I use SQL scripts with Supabase resource in Windmill (self-hosted)?
I'm migrating my self-hosted PostgreSQL db to Supabase and trying to integrate it with my self-hosted Windmill instance
https://www.windmill.dev/docs/integrations/supabase
The guide recommends setting up Supabase as a resource using the url and key. This works for querying through TypeScript
I have a number of existing PostgreSQL scripts and prefer using SQL for quick tasks, however, with the Supabase resource type, I haven’t found a way to execute raw SQL scripts as I could with a standard PostgreSQL resource
I know that I can connect to supabase using their postgres url but I think that since the docs recommend this and I don't want to have duplicate resources for each thing I want to run, how to connect supabase properly
Should I connect so supabase with oauth? I am unable to select it as one of the items, is it because I am not in the admin account and if yes, how can the admin set it up?
https://www.windmill.dev/docs/integrations/supabase
The guide recommends setting up Supabase as a resource using the url and key. This works for querying through TypeScript
I have a number of existing PostgreSQL scripts and prefer using SQL for quick tasks, however, with the Supabase resource type, I haven’t found a way to execute raw SQL scripts as I could with a standard PostgreSQL resource
I know that I can connect to supabase using their postgres url but I think that since the docs recommend this and I don't want to have duplicate resources for each thing I want to run, how to connect supabase properly
Should I connect so supabase with oauth? I am unable to select it as one of the items, is it because I am not in the admin account and if yes, how can the admin set it up?
Supabase is an open-source Firebase alternative.
