---
name: watsonxdata-dbt-watsonx-presto
title: dbt-watsonx-presto (data build tool adapter for Presto)
description: '`dbt-watsonx-presto` is a data build tool (dbt) adapter that is designed to connect dbt Core with Presto. This adapter helps to build, test, and document data models in Presto.'
last-updated: 2024-11-18
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/watsonxdata?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

# dbt-watsonx-presto (data build tool adapter for Presto)
{: #dbt_watsonx_presto}

`dbt-watsonx-presto` is a data build tool (dbt) adapter that is designed to connect dbt Core with Presto. This adapter helps to build, test, and document data models in Presto.

For more information about dbt, see:

- [What is dbt?](https://docs.getdbt.com/docs/introduction)
- [About dbt projects](https://docs.getdbt.com/docs/build/projects)

For information about setting up your profile, see [Configuration (setting up your profile)](https://cloud.ibm.com/docs/watsonxdata?topic=watsonxdata-dbt_watsonx_presto_conf&format=markdown).

For information about installing and using `dbt-watsonx-presto`, see [Installing and using dbt-watsonx-presto](https://cloud.ibm.com/docs/watsonxdata?topic=watsonxdata-dbt_watsonx_presto_inst&format=markdown).

## Limitations
{: #dbt_watsonx_presto_limit}

- The following features of dbt are not supported on Presto:
   - Archival
   - Incremental models
- The Presto and connector-related limitations are applicable to dbt also.

## Basic dbt commands
{: #dbt_watsonx_presto_cmd}

- **Initialize a dbt project**: Set up a new dbt project.

   ```bash
   dbt init my_project
   ```
   {: codeblock}

- **Debug dbt connection**: Test your dbt profile and connection.

   ```bash
   dbt debug
   ```
   {: codeblock}

- **Seed data**: Load seed data into your database/datasource.

   ```bash
   dbt seed
   ```
   {: codeblock}

- **Run dbt models**: Build and run your models.

   ```bash
   dbt run
   ```
   {: codeblock}

- **Test dbt models**: Run tests on your models.

   ```bash
   dbt test
   ```
   {: codeblock}

- **Generate documentation**: Create and serve documentation for your dbt project.

   ```bash
   dbt docs generate
   dbt docs serve
   ```
   {: codeblock}

For more information about dbt commands, see [dbt command reference](https://docs.getdbt.com/reference/dbt-commands).