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 Cloud 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:

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.

1. Joining the results of show tables and show views.