search

microsoft / dbt-synapse

dbt adapter for Azure Synapse Dedicated SQL Pools
https://dbt-msft.github.io/dbt-msft-docs/docs/dbt-synapse/overview
MIT License
68 stars 28 forks source link

Version of adapter is not visible for `dbt --version` command #226

Open xemuliam opened 4 months ago

xemuliam commented 4 months ago

The common way to know the version of dbt and installed adapters is command dbt --version. However, for dbt-synapse and dbt-fabric adapters there is no such information at all.

Is is possible to add such information there?

Here is the log of insatllation/re-installation and output for version command:

root@819a2d99aa78:/# pip install -U dbt-synapse
Requirement already satisfied: dbt-synapse in /usr/local/lib/python3.11/site-packages (1.7.0)
Requirement already satisfied: dbt-fabric~=1.7.4 in /usr/local/lib/python3.11/site-packages (from dbt-synapse) (1.7.4)
Requirement already satisfied: dbt-core~=1.7.2 in /usr/local/lib/python3.11/site-packages (from dbt-fabric~=1.7.4->dbt-synapse) (1.7.10)
Requirement already satisfied: pyodbc<5.1.0,>=4.0.35 in /usr/local/lib/python3.11/site-packages (from dbt-fabric~=1.7.4->dbt-synapse) (5.0.1)
Requirement already satisfied: azure-identity>=1.12.0 in /usr/local/lib/python3.11/site-packages (from dbt-fabric~=1.7.4->dbt-synapse) (1.15.0)
Requirement already satisfied: azure-core<2.0.0,>=1.23.0 in /usr/local/lib/python3.11/site-packages (from azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (1.30.1)
Requirement already satisfied: cryptography>=2.5 in /usr/local/lib/python3.11/site-packages (from azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (42.0.5)
Requirement already satisfied: msal<2.0.0,>=1.24.0 in /usr/local/lib/python3.11/site-packages (from azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (1.27.0)
Requirement already satisfied: msal-extensions<2.0.0,>=0.3.0 in /usr/local/lib/python3.11/site-packages (from azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (1.1.0)
Requirement already satisfied: agate~=1.7.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.7.1)
Requirement already satisfied: Jinja2<4,>=3.1.3 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (3.1.3)
Requirement already satisfied: mashumaro~=3.9 in /usr/local/lib/python3.11/site-packages (from mashumaro[msgpack]~=3.9->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (3.12)
Requirement already satisfied: logbook<1.6,>=1.5 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.5.3)
Requirement already satisfied: click<9,>=8.0.2 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (8.1.7)
Requirement already satisfied: networkx<4,>=2.3 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (3.2.1)
Requirement already satisfied: colorama<0.5,>=0.3.9 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.4.6)
Requirement already satisfied: pathspec<0.12,>=0.9 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.11.2)
Requirement already satisfied: isodate<0.7,>=0.6 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.6.1)
Requirement already satisfied: sqlparse<0.5,>=0.2.3 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.4.4)
Requirement already satisfied: dbt-extractor~=0.5.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.5.1)
Requirement already satisfied: minimal-snowplow-tracker~=0.0.2 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.0.2)
Requirement already satisfied: dbt-semantic-interfaces~=0.4.2 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.4.4)
Requirement already satisfied: jsonschema>=3.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (4.21.1)
Requirement already satisfied: packaging>20.9 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (24.0)
Requirement already satisfied: protobuf<5,>=4.0.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (4.25.3)
Requirement already satisfied: pytz>=2015.7 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2024.1)
Requirement already satisfied: pyyaml>=6.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (6.0.1)
Requirement already satisfied: typing-extensions>=3.7.4 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (4.10.0)
Requirement already satisfied: cffi<2.0.0,>=1.9 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.16.0)
Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (3.6)
Requirement already satisfied: requests<3.0.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.31.0)
Requirement already satisfied: urllib3~=1.0 in /usr/local/lib/python3.11/site-packages (from dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.26.18)
Requirement already satisfied: Babel>=2.0 in /usr/local/lib/python3.11/site-packages (from agate~=1.7.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.14.0)
Requirement already satisfied: leather>=0.3.2 in /usr/local/lib/python3.11/site-packages (from agate~=1.7.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.4.0)
Requirement already satisfied: parsedatetime!=2.5,>=2.1 in /usr/local/lib/python3.11/site-packages (from agate~=1.7.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.6)
Requirement already satisfied: python-slugify>=1.2.1 in /usr/local/lib/python3.11/site-packages (from agate~=1.7.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (8.0.4)
Requirement already satisfied: pytimeparse>=1.1.5 in /usr/local/lib/python3.11/site-packages (from agate~=1.7.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.1.8)
Requirement already satisfied: six>=1.11.0 in /usr/local/lib/python3.11/site-packages (from azure-core<2.0.0,>=1.23.0->azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (1.16.0)
Requirement already satisfied: pycparser in /usr/local/lib/python3.11/site-packages (from cffi<2.0.0,>=1.9->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.21)
Requirement already satisfied: importlib-metadata~=6.0 in /usr/local/lib/python3.11/site-packages (from dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (6.11.0)
Requirement already satisfied: more-itertools<11.0,>=8.0 in /usr/local/lib/python3.11/site-packages (from dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (10.2.0)
Requirement already satisfied: pydantic<3,>=1.10 in /usr/local/lib/python3.11/site-packages (from dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.6.4)
Requirement already satisfied: python-dateutil~=2.0 in /usr/local/lib/python3.11/site-packages (from dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.9.0.post0)
Requirement already satisfied: MarkupSafe>=2.0 in /usr/local/lib/python3.11/site-packages (from Jinja2<4,>=3.1.3->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.1.5)
Requirement already satisfied: attrs>=22.2.0 in /usr/local/lib/python3.11/site-packages (from jsonschema>=3.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (23.2.0)
Requirement already satisfied: jsonschema-specifications>=2023.03.6 in /usr/local/lib/python3.11/site-packages (from jsonschema>=3.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2023.12.1)
Requirement already satisfied: referencing>=0.28.4 in /usr/local/lib/python3.11/site-packages (from jsonschema>=3.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.33.0)
Requirement already satisfied: rpds-py>=0.7.1 in /usr/local/lib/python3.11/site-packages (from jsonschema>=3.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.18.0)
Requirement already satisfied: msgpack>=0.5.6 in /usr/local/lib/python3.11/site-packages (from mashumaro[msgpack]~=3.9->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.0.8)
Requirement already satisfied: PyJWT<3,>=1.0.0 in /usr/local/lib/python3.11/site-packages (from PyJWT[crypto]<3,>=1.0.0->msal<2.0.0,>=1.24.0->azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (2.8.0)
Requirement already satisfied: portalocker<3,>=1.0 in /usr/local/lib/python3.11/site-packages (from msal-extensions<2.0.0,>=0.3.0->azure-identity>=1.12.0->dbt-fabric~=1.7.4->dbt-synapse) (2.8.2)
Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.11/site-packages (from requests<3.0.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (3.3.2)
Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.11/site-packages (from requests<3.0.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2024.2.2)
Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.11/site-packages (from importlib-metadata~=6.0->dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (3.18.1)
Requirement already satisfied: annotated-types>=0.4.0 in /usr/local/lib/python3.11/site-packages (from pydantic<3,>=1.10->dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (0.6.0)
Requirement already satisfied: pydantic-core==2.16.3 in /usr/local/lib/python3.11/site-packages (from pydantic<3,>=1.10->dbt-semantic-interfaces~=0.4.2->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (2.16.3)
Requirement already satisfied: text-unidecode>=1.3 in /usr/local/lib/python3.11/site-packages (from python-slugify>=1.2.1->agate~=1.7.0->dbt-core~=1.7.2->dbt-fabric~=1.7.4->dbt-synapse) (1.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
root@819a2d99aa78:/# dbt --version
Core:
  - installed: 1.7.10
  - latest:    1.7.10 - Up to date!

Plugins:

root@819a2d99aa78:/#
xemuliam commented 3 months ago

any update?

xemuliam commented 2 months ago

^ ^ ^ ^ ^ ^ @dataders