Skip to content

Ignore Pipelines ANSI backend default drift - #6813

Open
shreyas-goenka wants to merge 7 commits into
mainfrom
shreyas/pipeline-ansi-default
Open

shreyas-goenka wants to merge 7 commits into
mainfrom
shreyas/pipeline-ansi-default

Conversation

@shreyas-goenka

@shreyas-goenka shreyas-goenka commented Sep 23, 2026 •

Copy link
Copy Markdown
Contributor

Changes

Treat spark.sql.ansi.enabled: "true" as a Pipelines backend default in the direct engine. Set the value explicitly in pipeline acceptance fixtures and shared templates to make the tests pass for TF, update the fake Pipelines API to match the backend, and regenerate affected goldens.

Why

The Pipelines API now injects this setting into every pipeline configuration. Without the default rule, direct-engine plans report persistent drift; without explicit fixture values, Terraform acceptance tests also report updates.

Tests

  • All acceptance tests selected by the changed pipeline fixtures pass without updating snapshots.
  • Default Python and Lakeflow pipeline template tests pass against regenerated outputs.
  • Direct-engine and test-server unit tests pass.
  • Focused Go lint and task checks pass.

This PR was written by Codex.

@github-actions github-actions Bot added DABs DABs related issues PyDABs labels Sep 23, 2026
@shreyas-goenka
shreyas-goenka marked this pull request as ready for review September 23, 2026 11:36
@eng-dev-ecosystem-bot

eng-dev-ecosystem-bot commented Sep 23, 2026 •

Copy link
Copy Markdown
Collaborator

Integration test report

Commit: 4e2eda5

Run: 35859670093

Env ❌​FAIL 🔄​flaky ✅​pass 🙈​skip Time
❌​ aws linux 4 320 52 14:59
❌​ aws windows 4 302 55 14:30
❌​ azure linux 4 319 52 13:48
❌​ azure windows 4 301 55 18:49
❌​ gcp linux 4 2 318 52 15:43
❌​ gcp windows 4 302 55 14:45
6 interesting tests: 4 FAIL, 2 flaky
Test Name aws linux aws windows azure linux azure windows gcp linux gcp windows
❌​ TestAccept ❌​F ❌​F ❌​F ❌​F ❌​F ❌​F
🔄​ TestAccept/bundle/resources/pipelines/allow-duplicate-names ✅​p ✅​p ✅​p ✅​p 🔄​f ✅​p
🔄​ TestAccept/bundle/resources/pipelines/allow-duplicate-names/DATABRICKS_BUNDLE_ENGINE=direct/DMS= ✅​p ✅​p ✅​p ✅​p 🔄​f ✅​p
❌​ TestAccept/bundle/resources/pipelines/drift/ansi-default ❌​F ❌​F ❌​F ❌​F ❌​F ❌​F
❌​ TestAccept/bundle/resources/pipelines/drift/ansi-default/DATABRICKS_BUNDLE_ENGINE=direct/DMS= ❌​F ❌​F ❌​F ❌​F ❌​F ❌​F
❌​ TestAccept/bundle/resources/pipelines/drift/ansi-default/DATABRICKS_BUNDLE_ENGINE=direct/DMS=true ❌​F ❌​F ❌​F ❌​F ❌​F ❌​F
Top 11 slowest tests (at least 2 minutes):
duration env testname
3:00 azure windows TestAccept/bundle/resources/pipelines/recreate/DATABRICKS_BUNDLE_ENGINE=terraform/DMS=
2:48 azure windows TestAccept/bundle/resources/pipelines/allow-duplicate-names/DATABRICKS_BUNDLE_ENGINE=direct/DMS=true
2:31 aws linux TestFilerWorkspaceFilesExtensionsReadDir
2:26 azure windows TestAccept/bundle/resources/pipelines/auto-approve/DATABRICKS_BUNDLE_ENGINE=direct/DMS=
2:16 gcp linux TestFilerRecursiveDelete/workspace_files
2:13 aws windows TestAccept/bundle/deployment/bind/pipelines/recreate/DATABRICKS_BUNDLE_ENGINE=terraform/DMS=
2:13 azure windows TestAccept/bundle/destroy/jobs-and-pipeline/DATABRICKS_BUNDLE_ENGINE=terraform/DMS=
2:06 aws linux TestAccept/bundle/resources/pipelines/recreate/DATABRICKS_BUNDLE_ENGINE=terraform/DMS=
2:05 azure windows TestFilerWorkspaceFilesExtensionsReadDir
2:04 gcp windows TestAccept/bundle/resources/pipelines/recreate/DATABRICKS_BUNDLE_ENGINE=terraform/DMS=
2:00 aws windows TestAccept/bundle/resources/pipelines/recreate/DATABRICKS_BUNDLE_ENGINE=direct/DMS=

pipelines:
foo:
configuration:
spark.sql.ansi.enabled: "true"

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

why did you add this here? and in other tests?

@denik denik left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

I don't think we want to modify every single test for this?

@shreyas-goenka

Copy link
Copy Markdown
Contributor Author

@denik the other solution would be to wait for a TF bump?

@shreyas-goenka

Copy link
Copy Markdown
Contributor Author

I'll check if we can just a prod rollback. This is a mistake on the lakeflow side.

This branch has not been deployed

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

Labels

DABs DABs related issues PyDABs

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants