`drizzle-kit migrate` fails with error `Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"`
🛠️drizzle kitSupabase📚sql
I don't understand why I'm getting this error and how to even get started fixing it. I found this GitHub issue, but it's marked as closed now. This is my
It's not a DB connection issue, because I'm able to run
select 1
select 1
using my Drizzle DB provider just fine. The schema already exists in my Supabase DB, because I have these two commands in the init script (and I checked they do get run successfully):
CREATE SCHEMA "drizzle";ALTER SCHEMA "drizzle" OWNER TO :"db_username";
CREATE SCHEMA "drizzle";ALTER SCHEMA "drizzle" OWNER TO :"db_username";