DT
Drizzle Team•3mo ago
Andrew Chung

drizzle-kit pull not working (freezes) with supabase

I'm trying to integrate drizzle to an existing supabase project with 77 tables. When i run npx drizzle-kit pull i see this log 
npm warn config ignoring workspace config at /Users/aschung/dev/typa/frontend/.npmrc
No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/aschung/dev/typa/frontend/drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'postgres' driver for database querying
[✓] 77 tables fetched
[⣟] 0  columns fetching
[✓] 33 enums fetched
[⣟] 0  indexes fetching
[⣟] 0  foreign keys fetching
[✓] 76 policies fetched
[⣟] 0  check constraints fetching
[⣟] 0  views fetching
npm warn config ignoring workspace config at /Users/aschung/dev/typa/frontend/.npmrc
No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/aschung/dev/typa/frontend/drizzle.config.ts'
Pulling from ['public'] list of schemas

Using 'postgres' driver for database querying
[✓] 77 tables fetched
[⣟] 0  columns fetching
[✓] 33 enums fetched
[⣟] 0  indexes fetching
[⣟] 0  foreign keys fetching
[✓] 76 policies fetched
[⣟] 0  check constraints fetching
[⣟] 0  views fetching
and the command hangs there forever. drizzle.config.ts looks like: 
import 'dotenv/config';
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
    out: './drizzle',
    schema: './src/db/schema/*',
    dialect: 'postgresql',
    dbCredentials: {
        url: process.env.DATABASE_URL!,
    },
    verbose: true,
    strict: true,
});
import 'dotenv/config';
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
    out: './drizzle',
    schema: './src/db/schema/*',
    dialect: 'postgresql',
    dbCredentials: {
        url: process.env.DATABASE_URL!,
    },
    verbose: true,
    strict: true,
});
Weird thing is when I add tableFilter: ["user"] to the config the command works, but once I add more tables to the filter or try it without filters the command freezes.
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?