skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

trino-dbt-platform

Configure dbt production projects for Trino with Iceberg materializations.

14|1|Updated May 5, 2026
Search Tags:#dbt#trino#snapshots#iceberg#ci cd#profiles.yml#incremental models
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill trino-dbt-platform
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: trino-dbt-platform
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/trino_group_skills/trino_dbt_platform
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill trino-dbt-platform

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill solves the problem of reliably running dbt projects in production on the Trino query engine while correctly handling Iceberg table layouts, incremental updates, and performance-friendly configuration.

Core Features & Use Cases

  • Production-ready dbt profiles.yml for Trino: Supports multiple authentication methods (ldap, kerberos, oauth, jwt, certificate) and includes practical session/query settings for stable execution.
  • End-to-end dbt materializations on Iceberg: Covers full-refresh outputs and incremental patterns (append, merge, delete+insert), plus table/view/materialized_view/ephemeral usage with Iceberg-specific properties (format, partitioning, sorted_by, location).
  • Incremental correctness and lifecycle management: Provides SCD2 snapshots via timestamp strategy, recommends Iceberg-compatible TIMESTAMP(6) handling, and includes an ANALYZE post-hook to keep cost-based optimization effective.
  • Faster CI pipelines: Implements slim dbt CI using state:modified+ with --defer and prior production artifacts to avoid unnecessary work.

Quick Start

Configure your dbt profiles.yml for Trino, set Iceberg properties in your model config blocks, then run dbt in CI using state:modified+ with --defer to build only changed models.

Frequently Asked Questions about trino-dbt-platform

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I configure dbt profiles.yml for Trino with Iceberg in production?▼

Configuring dbt profiles.yml for Trino involves setting the Trino adapter with authentication methods like ldap or kerberos and applying session query settings. This provides a stable execution environment for production Iceberg workloads.

What is the best way to handle incremental models in dbt on Trino?▼

The best way to handle dbt incremental models on Trino is using append, merge, and delete+insert patterns. This ensures correct incremental updates and lifecycle management for Iceberg tables with proper materialization configurations.

Does the Trino dbt adapter support SCD2 snapshots with TIMESTAMP(6)?▼

The Trino dbt adapter supports SCD2 snapshots using a timestamp strategy with Iceberg-compatible TIMESTAMP(6) handling. This maintains snapshot precision and ensures accurate historical data tracking.

How do I run slim dbt CI pipelines using state:modified+ and --defer?▼

To run slim dbt CI pipelines, use state:modified+ with --defer and prior production artifacts. This builds only changed models, avoiding unnecessary work and significantly speeding up continuous integration.

Can I use Iceberg table properties like partitioning and sorted_by in dbt model configs?▼

You can define Iceberg table properties like partitioning, sorted_by, format, and storage location directly in dbt model config blocks. This customization enables optimized query performance through specific Iceberg table layouts.

Why should I use a post-hook ANALYZE on dbt Iceberg models in Trino?▼

A post-hook ANALYZE on dbt Iceberg models updates table statistics to keep cost-based optimization effective. This ensures the Trino query optimizer generates efficient execution plans for your data.

Related Skills

Explore More Software Engineering Skills→
ivanshamaevivanshamaev
14

dbt_trino

Configure dbt profiles and incremental models for Trino and Starburst.

Community
Advanced
ivanshamaevivanshamaev
14

trino-dbt-query-performance

Optimize dbt-generated SQL performance on Trino with materializations and incremental strategies.

Community
Advanced
ivanshamaevivanshamaev
14

dbt-starrocks-production-readiness

Configure dbt StarRocks production readiness with RBAC, secrets, and slim CI.

Community
Advanced
sfc-gh-dflipposfc-gh-dflippo
34

dbt-performance

Optimize dbt model builds and Snowflake queries with materialization and clustering strategies.

Community
Intermediate