I need to create a db for integration testing. Can I set an additional env variable, ie., DATABASE_URL_TEST, rather than creat an other .env file?

Prisma only accepts a single environment variable, so you would need to keep the env variable same. Also that’s the recommended approach to switch env files instead of using different env variables.

Ok thanks