Configuration (setting up your profile)

To connect dbt Core to your Presto engine, configure the profiles.yml file that is located in .dbt of your home directory.

watsonx.data on IBM Software Hub

watsonx.data Developer edition

The following is an example configuration:

my_project:
  outputs:
    on-prem:
      type: presto
      method: BasicAuth
      user: username
      password: password
      host: internal/external host
      port: 443
      database: analytics
      schema: dbt_drew
      threads: 8
      ssl_verify: path/to/certificate
  target: on-prem

The following table covers the parameter details:

Table 1.
Option	Required/Optional	Description	Example
`method`	Optional (default value is none)	Authentication method for Presto.	None or `BasicAuth`
`user`	Required	Username for authentication.	drew
`password`	Required if method is `BasicAuth`	Password or API key for authentication.	None or alphanumeric
`http_headers`	Optional	HTTP headers to send alongside requests to Presto, specified as a yaml dictionary of (header, value) pairs.	X-Presto-Routing-Group: my-cluster
`http_scheme`	Optional (default is http or https for method: `BasicAuth`)	HTTP scheme to use (`http` or `https`).	`https` or `http`
`database`	Required	Catalog name for building models.	Analytics
`schema`	Required	Schema for building models.	`dbt_drew`
`host`	Required	Hostname for connecting to Presto. You can get the hostname by clicking View connect details in the engine details page.	127.0.0.1
`port`	Required	Port for connecting to Presto. You can get the port by clicking View connect details in the engine details page.	8080
`threads`	Optional (default is 1)	Number of threads for dbt operations.	8
`ssl_verify`	Required	Path to the SSL certificate. To obtain the certificate, run the following command and save the certificate to the specified location. `openssl s_client -showcerts -connect <host>:<port>`	path/to/certificate