# Connect iomete to dbt Core

Local development

* **Maintained by**: iomete
* **Authors**: Namig Aliyev
* **GitHub repo**: [iomete/dbt-iomete](https://github.com/iomete/dbt-iomete) [![](https://img.shields.io/github/stars/iomete/dbt-iomete?style=for-the-badge)](https://github.com/iomete/dbt-iomete)
* **PyPI package**: `dbt-iomete` [![](https://badge.fury.io/py/dbt-iomete.svg)](https://badge.fury.io/py/dbt-iomete)
* **Slack channel**: [##db-iomete](https://getdbt.slack.com/archives/C03JFG22EP9)
* **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. Use the following command for installation:

`python -m pip install dbt-iomete`

## Configuring dbt-iomete

For iomete-specific configuration, please refer to [iomete configs.](../../../reference/resource-configs/no-configs.md)

Set up a iomete Target

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

profiles.yml

```yaml
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<br />`account_number` with the prefix `dwh-`<br />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`.

## Was this page helpful?

YesNo

[Privacy policy](https://www.getdbt.com/cloud/privacy-policy)[Create a GitHub issue](https://github.com/dbt-labs/docs.getdbt.com/issues)

This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply.