IBM Cloud Docs
dbt-watsonx-presto (data build tool adapter for Presto)

dbt-watsonx-presto (data build tool adapter for 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:

For information about setting up your profile, see Configuration (setting up your profile).

For information about installing and using dbt-watsonx-presto, see Installing and using dbt-watsonx-presto.

Limitations

  • 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

  • Initialize a dbt project: Set up a new dbt project.

    dbt init my_project
    
  • Debug dbt connection: Test your dbt profile and connection.

    dbt debug
    
  • Seed data: Load seed data into your database/datasource.

    dbt seed
    
  • Run dbt models: Build and run your models.

    dbt run
    
  • Test dbt models: Run tests on your models.

    dbt test
    
  • Generate documentation: Create and serve documentation for your dbt project.

    dbt docs generate
    dbt docs serve
    

For more information about dbt commands, see dbt command reference.