Skip to main content

iomete setup

Overview of dbt-iomete

  • 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

Installation and Distribution

Installing dbt-iomete

pip is the easiest way to install the adapter:

pip install dbt-iomete

Installing dbt-iomete will also install dbt-core and any other dependencies.

Configuring dbt-iomete

For iomete-specifc configuration please refer to iomete Configuration

For further info, refer to the GitHub repository: iomete/dbt-iomete

Set up a iomete Target

iomete targets should be set up using the following configuration in your profiles.yml file.

target: dev
type: iomete
cluster: cluster_name
host: <region_name>
port: 443
schema: database_name
account_number: iomete_account_number
user: iomete_user_name
password: iomete_user_password
Description of Profile Fields
typeThe specific adapter to useRequirediomete
clusterThe cluster to connectRequiredreporting
hostThe host name of the connection. It is a combination of
account_number with the prefix dwh-
and the suffix
portThe port to use.Required443
schemaSpecify the schema (database) to build models into.Requireddbt_finance
account_numberThe iomete account number with single quotes.Required'1234566789123'
usernameThe iomete username to use to connect to the server.Requireddbt_user
passwordThe iomete user password to use to connect to the server.Requiredstrong_password

Supported Functionality

Most dbt Core functionality is supported.

Iceberg specific improvements.

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