Skip to content

fix: support sql_filter in explores config#21841

Merged
Spissable merged 1 commit intomainfrom
feature/prod-6867
Apr 9, 2026
Merged

fix: support sql_filter in explores config#21841
Spissable merged 1 commit intomainfrom
feature/prod-6867

Conversation

@Spissable
Copy link
Copy Markdown
Contributor

Closes: https://linear.app/lightdash/issue/PROD-6867/sql-filter-is-not-working-in-the-explores-config-for-models

Description:

sql_filter was silently ignored when set inside an explores block because the ExploreConfig type and translator logic didn't handle it.

Testing:

I tested with "Completed Orders"
image

Before:

Note: no where clause

before

After:

Note: "where clause" is present

after

@Spissable Spissable requested a review from jesshitchcock April 8, 2026 12:40
@linear
Copy link
Copy Markdown

linear Bot commented Apr 8, 2026

@github-actions
Copy link
Copy Markdown

github-actions Bot commented Apr 8, 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 8, 2026

Your preview environment pr-21841 has been deployed.

Preview environment endpoints are available at:

@github-actions
Copy link
Copy Markdown

github-actions Bot commented Apr 8, 2026

Preview Environment

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

📋 Logs: View in GCP Console

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

sql_filter was silently ignored when set inside an `explores` block
because the ExploreConfig type and translator logic didn't handle it.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
@Spissable Spissable force-pushed the feature/prod-6867 branch from 8ad83dc to cc2e902 Compare April 9, 2026 15:36
@Spissable Spissable merged commit 3ea86bb into main Apr 9, 2026
23 checks passed
@Spissable Spissable deleted the feature/prod-6867 branch April 9, 2026 15:59
lightdash-bot pushed a commit that referenced this pull request Apr 9, 2026
## [0.2745.1](0.2745.0...0.2745.1) (2026-04-09)

### Bug Fixes

* support sql_filter in explores config (PROD-6867) ([#21841](#21841)) ([3ea86bb](3ea86bb))
@lightdash-bot
Copy link
Copy Markdown
Collaborator

🎉 This PR is included in version 0.2745.1 🎉

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.

2 participants