running a dbt container that has postgres + bigquery + oracle

[avnav0]

it seems that oracle's plugin version requires the older core of 1.1.2, while the other ones run on a core of 1.2.0.

so when i try to install the oracle plugin, the core gets downgraded:

Installing collected packages: cx-Oracle, networkx, colorama, cryptography, oracledb, dbt-core, dbt-oracle
  Attempting uninstall: networkx
    Found existing installation: networkx 2.8.5
    Uninstalling networkx-2.8.5:
      Successfully uninstalled networkx-2.8.5
  Attempting uninstall: colorama
    Found existing installation: colorama 0.4.5
    Uninstalling colorama-0.4.5:
      Successfully uninstalled colorama-0.4.5
  Attempting uninstall: dbt-core
    Found existing installation: dbt-core 1.2.0
    Uninstalling dbt-core-1.2.0:
      Successfully uninstalled dbt-core-1.2.0
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
dbt-postgres 1.2.0 requires dbt-core==1.2.0, but you have dbt-core 1.1.2 which is incompatible.
dbt-bigquery 1.2.0 requires dbt-core~=1.2.0, but you have dbt-core 1.1.2 which is incompatible.
Successfully installed colorama-0.4.4 cryptography-37.0.4 cx-Oracle-8.3.0 dbt-core-1.1.2 dbt-oracle-1.1.2 networkx-2.8.3 oracledb-1.0.3
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

[notice] A new release of pip available: 22.2 -> 22.2.2
[notice] To update, run: pip install --upgrade pip
root@LC48L8S2:/home/user123/_volumes/_dbt/_profiles# nano /home/user123/_volumes/_dbt/bigquery_test/constart.sh
root@LC48L8S2:/home/user123/_volumes/_dbt/_profiles# podman start -a dbt
19:13:31  oracle adapter: Running in cx mode
Core:
  - installed: 1.1.2
  - latest:    1.2.0 - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - bigquery: 1.2.0 - Not compatible!
  - postgres: 1.2.0 - Not compatible!
  - oracle:   1.1.2 - Up to date!

  At least one plugin is out of date or incompatible with dbt-core.
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

[avnav0]

when i try to update the core:

Installing collected packages: dbt-core
  Attempting uninstall: dbt-core
    Found existing installation: dbt-core 1.1.2
    Uninstalling dbt-core-1.1.2:
      Successfully uninstalled dbt-core-1.1.2
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
dbt-oracle 1.1.2 requires dbt-core==1.1.2, but you have dbt-core 1.2.0 which is incompatible.
Successfully installed dbt-core-1.2.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
root@LC48L8S2:/home/user123/_volumes/_dbt/_profiles# nano /home/user123/_volumes/_dbt/bigquery_test/constart.sh
root@LC48L8S2:/home/user123/_volumes/_dbt/_profiles# podman start -a dbt
19:28:26  oracle adapter: Running in cx mode
Core:
  - installed: 1.2.0
  - latest:    1.2.0 - Up to date!

Plugins:
  - bigquery: 1.2.0 - Up to date!
  - postgres: 1.2.0 - Up to date!
  - oracle:   1.1.2 - Not compatible!

  At least one plugin is out of date or incompatible with dbt-core.
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation
root@LC48L8S2:/home/user123/_volumes/_dbt/_profiles#

[joellabes]

Hey @avnav88, you are correct that dbt-oracle requires Core 1.1.2 exactly.

You won't be able to have v1.1 and v1.2 of dbt Core in play simultaneously, but you could install v1.1.x of dbt-postgres and dbt-bigquery instead. If you define all the packages you want in a single command, then pip will work out the highest compatible version for all of them. For example pip install dbt-core dbt-oracle dbt-bigquery dbt-postgres followed by dbt --version gave me:

Core:
  - installed: 1.1.2
  - latest:    1.2.0 - Update available!

  Your version of dbt-core is out of date!
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

Plugins:
  - oracle:   1.1.2 - Up to date!
  - bigquery: 1.1.1 - Update available!
  - postgres: 1.1.2 - Update available!

  At least one plugin is out of date or incompatible with dbt-core.
  You can find instructions for upgrading here:
  https://docs.getdbt.com/docs/installation

If you want to pin to a specific minor version, you could also do something like
pip install dbt-core~=1.1.0 dbt-oracle~=1.1.0 dbt-bigquery~=1.1.0 dbt-postgres~=1.1.0 --upgrade, which will give the highest patch version for each of the packages.

☝️ fair warning: my pip is a bit shaky so there might be a better option than this