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

dbt-starrocks-models

Generate StarRocks-compatible dbt model definitions with DDL and incremental strategies.

14|1|Updated May 5, 2026
Search Tags:#dbt#partitioning#upsert#starrocks#adapter configuration#incremental models#table ddl
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-starrocks-models
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-starrocks-models
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/dbt_starrocks_models
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-starrocks-models

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the problem of defining dbt models that correctly produce StarRocks table DDLs, materializations, and incremental behaviors with the right StarRocks-specific configuration.

Core Features & Use Cases

  • Model materializations for StarRocks: Supports table, view, incremental, and ephemeral patterns tailored to dbt-starrocks.
  • StarRocks-specific model config: Enables setting engine/table_type, keys, partition_by, distributed_by, buckets, and table properties from dbt config.
  • Incremental strategies that match StarRocks patterns: Covers append, insert_overwrite (partition replace), and unique_key upsert requirements with on_schema_change controls.
  • Practical DDL patterns: Provides DBT-style examples for Duplicate/Primary/Aggregate key table creation and partitioning with date granularity.

Quick Start

Use the dbt-starrocks configuration to create StarRocks tables and incremental models by running dbt with profiles configured for your StarRocks host and credentials.

Frequently Asked Questions about dbt-starrocks-models

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

FAQPage Schema
How do I configure dbt incremental models for StarRocks upserts and partition replacement?▼

To configure dbt incremental models for StarRocks, you specify the incremental_strategy as append, insert_overwrite for partition replacement, or use unique_key for upserts, while controlling on_schema_change behavior in your model config.

How do I define table DDL and distribution keys in a dbt StarRocks project?▼

You define StarRocks table DDL and distribution in dbt by setting model configs for distributed_by, buckets, engine, table_type, and keys, ensuring production analytics pipelines generate correct physical table structures.

What StarRocks table properties do I need to set in dbt for primary and aggregate key tables?▼

StarRocks primary and aggregate key tables in dbt require specifying the engine, table_type, and appropriate key configurations within your model definition to generate the correct DDL patterns for data storage.

Does dbt work with StarRocks for staging, silver, and gold transformation layers?▼

dbt works with StarRocks for staging, silver, and gold layers by using the dbt-starrocks adapter, allowing you to build transformation pipelines with table, view, incremental, and ephemeral materializations.

How do I set up the dbt-starrocks adapter in profiles.yml for my analytics pipeline?▼

To set up the dbt-starrocks adapter, you configure your profiles.yml with the correct StarRocks host and credentials, enabling dbt to connect and execute model materializations against your database.

Why are my dbt StarRocks incremental loads failing when the schema changes?▼

dbt StarRocks incremental loads fail on schema changes if on_schema_change behavior is not properly configured, requiring you to adjust incremental_strategy and schema evolution settings in the model config.

Related Skills

Explore More Software Engineering Skills→
ivanshamaevivanshamaev
14

dbt_trino

Configure dbt profiles and incremental models for Trino and Starburst.

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

dbt-materializations

Select and implement dbt materializations for models with configuration options.

Community
Intermediate
jpoutrinjpoutrin
14

dbt

Generates dbt staging, intermediate, and model code with tests and documentation.

Community
Intermediate
Aniket-a14Aniket-a14
1

senior-data-engineer

Design production-grade data pipelines with Python, Spark, Airflow, dbt, and Kafka.

Community
Advanced