Configure dbt profiles and incremental models for Trino and Starburst.
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-trino
Please help me install this Agent Skill. Skill: dbt_trino Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/skills/dbt_trino Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-trino
dbt + Trino projects often fail or underperform due to misconfigured profiles/authentication, incorrect materialization choices, unsafe incremental logic, or missing engine/session/table properties.
Use the dbt_trino skill to generate a Trino-targeted profiles.yml and a production-ready incremental model config for Iceberg tables using the merge strategy.
High-intent search queries and answers about installing and using this skill.
Configure dbt Trino profiles.yml by selecting the correct authentication method—none, ldap, kerberos, jwt, certificate, or oauth—and storing secrets in environment variables for production-safe connectivity.
The best incremental model strategy for dbt Iceberg tables on Trino uses the merge strategy, combined with incremental_predicates and correct on_schema_change behavior to manage updates safely and reduce scan costs.
dbt works with Starburst for data modeling by configuring Trino-compatible targets, supporting materializations like materialized_view and incremental, and applying engine-specific session_properties for pipeline execution.
Structure a dbt Trino project by organizing models into staging, intermediate, and marts layers, selecting table, view, incremental, or ephemeral materializations that fit Trino connector capabilities and querying patterns.
dbt incremental pipelines fail on Trino Hive tables during schema changes when on_schema_change is misconfigured; setting correct Iceberg, Hive, or Delta table properties and using full-refresh guidance resolves connector-specific pitfalls.
You can use delete+insert, append, and merge strategies for dbt incremental models on Trino, applying session_properties and incremental_predicates to optimize performance and avoid connector-specific execution errors.
treasure-dataConfigure dbt models for Treasure Data Trino with API-key authentication.
JingyiWngCreate and manage Apache Iceberg tables on Databricks with REST Catalog.
ivanshamaevDeploy a local Trino lakehouse with Iceberg, Hive Metastore, and MinIO.
sfc-gh-dflippoOptimize dbt model builds and Snowflake queries with materialization and clustering strategies.
