Configure dbt

Configure dbt to connect to your Teradata database. Create a profiles.yml file in the location shown below.

Windows

Run in Powershell:

c:\Users\<username>\.dbt\profiles.yml

MacOS

~/.dbt/profiles.yml

Linux

~/.dbt/profiles.yml

Add the following configuration to the profiles.yml file. Adjust <host>, <user>, and <password> to match your Teradata instance.

Note

Database setup

The following dbt profile points to a database called jaffle_shop. If the database doesn't exist on your Teradata Database instance, it will be created. You can also change schema value to point to an existing database in your instance.

jaffle_shop:
  outputs:
    dev:
      type: teradata
      host: <host>
      user: <user>
      password: <password>
      logmech: TD2
      schema: jaffle_shop
      tmode: ANSI
      threads: 1
      timeout_seconds: 300
      priority: interactive
      retries: 1
  target: dev

Now that the profile file is in place, validate the setup:

dbt debug

If the debug command returns errors, you likely have an issue with the content of profiles.yml.