Skip to content

[FEATURE]: Ability to filter / manage tables by schema on drizzle-kit push / pull #3967

@heinsenberg82

Description

@heinsenberg82

Feature hasn't been suggested before.

  • I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

It would be nice if one should be able to filter tables by schema, when choosing the tables that will be managed by drizzle-kit push or drizzle-kit pull.

For instance, my project uses Supabase and I need to manage all the tables inside public schema, but also only the objects table inside storage schema (reason: to apply and manage access control policies).

If i do schemaFilter: ["public", "storage"] on drizzle.config.ts, when I call npx drizzle-kit push Drizzle wants to drop all other tables inside storage schema, since I'm not defining / managing them inside my code.

And using only the tablesFilter would be a pain, since I would have to check the list of filtered tables every time I change my database schema.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions