Skip to content

feat: support dbt seeds as join targets#21812

Merged
Spissable merged 1 commit intomainfrom
feature/prod-6187
Apr 13, 2026
Merged

feat: support dbt seeds as join targets#21812
Spissable merged 1 commit intomainfrom
feature/prod-6187

Conversation

@Spissable
Copy link
Copy Markdown
Contributor

Closes: https://linear.app/lightdash/issue/PROD-6187/joins-with-dbt-seedssources-silently-fail

Description:

Seeds are now included in the compilation pipeline so they can be used as join targets from models, eliminating the need for wrapper models that just SELECT * FROM {{ ref('seed') }}. Seeds are compiled as tables for join resolution but do not create standalone explores.

Screenshot 2026-04-07 at 16 50 08

@linear
Copy link
Copy Markdown

linear Bot commented Apr 7, 2026

@Spissable Spissable requested a review from jesshitchcock April 7, 2026 15:56
@Spissable Spissable changed the title feat: support dbt seeds as join targets (PROD-6187) feat: support dbt seeds as join targets Apr 7, 2026
@github-actions
Copy link
Copy Markdown

github-actions Bot commented Apr 7, 2026

🧪 Test Selection

✅ Tests that will run

Test Description
Preview Environment Deploys a preview environment for testing
Frontend E2E Tests Runs Cypress app tests
Backend API Tests Runs Vitest API tests
CLI Tests Runs CLI integration and dbt version tests

⏭️ Tests skipped (no relevant file changes detected)

Test How to trigger manually
Timezone Tests Add test-timezone to PR description

Tip: Add test-all to your PR description to run all tests.

@github-actions
Copy link
Copy Markdown

github-actions Bot commented Apr 7, 2026

Your preview environment pr-21812 has been deployed.

Preview environment endpoints are available at:

@github-actions
Copy link
Copy Markdown

github-actions Bot commented Apr 7, 2026

Preview Environment

🌐 URL: https://lightdash-preview-pr-21812.lightdash.okteto.dev

📋 Logs: View in GCP Console

🔧 SSH: ./scripts/okteto-ssh.sh 21812

@jesshitchcock
Copy link
Copy Markdown
Contributor

My test case ended up being pretty complex but I got it working in the end. Note it was a bit annoying to have to manually add the YAML for my seed (lightdash generate only works for models).

Copy link
Copy Markdown
Contributor

@jesshitchcock jesshitchcock left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

My test case ended up being pretty complex but I got it working in the end. Note it was a bit annoying to have to manually add the YAML for my seed (lightdash generate only works for models).

Seeds are now included in the compilation pipeline so they can be used
as join targets from models, eliminating the need for wrapper models
that just `SELECT * FROM {{ ref('seed') }}`. Seeds are compiled as
tables for join resolution but do not create standalone explores.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
@Spissable Spissable marked this pull request as ready for review April 13, 2026 11:31
@Spissable Spissable merged commit eda449c into main Apr 13, 2026
21 of 23 checks passed
@Spissable Spissable deleted the feature/prod-6187 branch April 13, 2026 13:06
lightdash-bot pushed a commit that referenced this pull request Apr 13, 2026
# [0.2753.0](0.2752.1...0.2753.0) (2026-04-13)

### Features

* support dbt seeds as join targets (PROD-6187) ([#21812](#21812)) ([eda449c](eda449c))
@lightdash-bot
Copy link
Copy Markdown
Collaborator

🎉 This PR is included in version 0.2753.0 🎉

The release is available on:

Your semantic-release bot 📦🚀

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants