iomete setup
- Maintained by: iomete
- Authors: Namig Aliyev
- GitHub repo: iomete/dbt-iomete
- PyPI package:
dbt-iomete
- Slack channel: ##db-iomete
- Supported dbt Core version: v0.18.0 and newer
- dbt support: Not Supported
- Minimum data platform version: n/a
Installing dbt-iomete
Use pip to install the adapter. Before 1.8, installing the adapter would automatically install dbt-core and any additional dependencies. Beginning in 1.8, installing an adapter does not automatically install dbt-core. This is because adapters and dbt Core versions have been decoupled from each other so we no longer want to overwrite existing dbt-core installations.
Use the following command for installation:
python -m pip install dbt-core dbt-iomete
Configuring dbt-iomete
For iomete-specific configuration, please refer to iomete configs.
Set up a iomete Target
iomete targets should be set up using the following configuration in your profiles.yml file.
profiles.yml
iomete:
target: dev
outputs:
dev:
type: iomete
cluster: cluster_name
host: <region_name>.iomete.com
port: 443
schema: database_name
account_number: iomete_account_number
user: iomete_user_name
password: iomete_user_password
Description of Profile Fields
| Field | Description | Required | Example |
|---|---|---|---|
| type | The specific adapter to use | Required | iomete |
| cluster | The cluster to connect | Required | reporting |
| host | The host name of the connection. It is a combination of account_number with the prefix dwh- and the suffix .iomete.com. | Required | dwh-12345.iomete.com |
| port | The port to use. | Required | 443 |
| schema | Specify the schema (database) to build models into. | Required | dbt_finance |
| account_number | The iomete account number with single quotes. | Required | '1234566789123' |
| username | The iomete username to use to connect to the server. | Required | dbt_user |
| password | The iomete user password to use to connect to the server. | Required | strong_password |
Supported Functionality
Most dbt Core functionality is supported.
Iceberg specific improvements.
- Joining the results of
show tablesandshow views.
Was this page helpful?
0