[BUG]: drizzle-kit up tries to use aws-data-api driver with dialect 'postgresql'

[L-Mario564]

What version of drizzle-orm are you using?

?

What version of drizzle-kit are you using?

?

Describe the Bug

From drizzle-kit-mirror repo: https://github.com/drizzle-team/drizzle-kit-mirror/issues/592.

I am upgrading from drizzle-kit v0.20.14 to v0.25.0.

The commit (where the issue appears) is here: sisou/bun-drizzle-chain-mirror@2591878

When I try to generate a new migration with bun drizzle-kit generate it tells me the snapshots are outdated and I need to run drizzle-kit up. This is the output:

> bun drizzle-kit up             
No config path provided, using default 'drizzle.config.ts'
Reading config file '/home/[...]/bun-drizzle-chain-mirror/drizzle.config.ts'
 Error  Please provide required params for AWS Data API driver:
    [x] database: undefined
    [✓] secretArn: 'postgresql'
error: "drizzle-kit" exited with code 1

For some reason it wants to use aws-data-api driver, but I don't think anything in the config file points to that:

import type { Config } from "drizzle-kit";

export default {
	dialect: "postgresql",
	schema: "./db/schema.ts",
	dbCredentials: {
		url: process.env.DATABASE_URL!,
	},
	verbose: true,
	strict: true,
} satisfies Config;

DATABASE_URL is a postgres:// URL.

Expected behavior

No response

Environment & setup

No response

[Dastari]

You can work around this by supply the "out" option to your drizzle.config

import type { Config } from "drizzle-kit";

export default {
	out: "./drizzle",
	dialect: "postgresql",
	schema: "./db/schema.ts",
	dbCredentials: {
		url: process.env.DATABASE_URL!,
	},
	verbose: true,
	strict: true,
} satisfies Config;

[AndriiSherman]

should not be an issue on latest(drizzle-orm@0.38.0+), if it's still an issue - please reopen

[TMSCH]

Hi there, I just ran into the same issue with the latest drizzle-orm when running drizzle-kit check. Adding the out parameter resolved it. I also tried specifying the pglite dialect but it seems this parameter wasn't picked up and the same AWS Data API related error showed up.

I'm using drizzle-orm version 0.39.3 and drizzle-kit version 0.30.4 (and disclaimer, I've just started using this library!).

My drizzle.config.ts:

export default defineConfig({
  out: './drizzle',
  dialect: 'postgresql',
  schema: './src/db/schema.ts',
  dbCredentials: {
    url: config.DATABASE_URL,
  },
});

Given there's a workaround, no urgency, but figured it was worth mentioning.

Thanks!

[JosepAlacid]

I don't know if you mean this is solved by adding the "out" parameter or it shouldn't be needed.
Anyway, without adding the out option, the message about AWS is still showing.

[TMSCH]

I wouldn't consider this solved even though adding the out parameter resolved the issue.

[eduardomoroni]

Still having the same issue on version "drizzle-kit": "0.31.4" adding out solves the issue though