Prompted to select btwn only Databricks or Spark after installing dbt-postgres

Help
,
1

The problem I’m having

After dbt init <my_proj_name>, I’m prompted to select between only two DBs (databricks, spark). There isn’t an obvious way to enter the db I want to use (postgres, which seems to be supported) or escape the CLI wizard and just create the profile manually.

The context of why I’m trying to do this

I’m trying to set up dbt with postgres.

What I’ve already tried

Entering the string postgres in response to the prompt.

Some example code or error messages

% pip install dbt-postgres
% dbt init <my_proj_name>
18:11:08  Running with dbt=1.7.9
18:11:08  
Your new dbt project "<my_proj_name>" was created!

For more information on how to configure the profiles.yml file,
please consult the dbt documentation here:

  https://docs.getdbt.com/docs/configure-your-profile

One more thing:

Need help? Don't hesitate to reach out to us via GitHub issues or on Slack:

  https://community.getdbt.com/

Happy modeling!

18:11:08  Setting up your profile.
Which database would you like to use?
[1] databricks
[2] spark

(Don't see the one you want? https://docs.getdbt.com/docs/available-adapters)

Enter a number: postgres
Error: 'postgres' is not a valid integer.
Which database would you like to use?
[1] databricks
[2] spark

(Don't see the one you want? https://docs.getdbt.com/docs/available-adapters)

Enter a number:
2

hey @leoebfolsom ! do you have dbt-core installed? i only see you installing dbt-postgres? you’ll want to try pip install dbt-core dbt-postgres on the latest version of dbt (which will be installed if a version is not specificed) (per Postgres setup | dbt Developer Hub)

1 Like
3

I bet that’s it, thanks! Will confirm when I’m at keyboard. For some reason, I mistakenly thought dbt-core was automatically installed in the env along with the adapter.