What this PR does / why we need it:

Adds comprehensive integration tests for the dbt import feature (PR #5827), which previously lacked end-to-end testing with actual dbt project setup and Feast CLI integration.

Changes

Test Infrastructure

• Created sdk/python/tests/integration/dbt/ with 600+ lines covering:
  • Manifest parsing with dbt-artifacts-parser
  • Tag filtering (feast, ml, recommendations)
  • Model selection by name
  • All 3 data source types (BigQuery, Snowflake, File)
  • Type mapping validation (INT32/64, FLOAT32/64, STRING, TIMESTAMP)
  • FeatureView generation with schema validation
  • Column exclusion (entity, timestamp, custom)
  • Code generation workflow

Test dbt Project

• Minimal dbt project in test_dbt_project/ with 3 models:
  • driver_features: INT types, multiple tags
  • customer_features: STRING entity
  • product_features: FLOAT32, tag filtering test
• Seed data (CSV files) for all three models to enable actual dbt execution
• DuckDB-only profile configuration for local testing without external service dependencies
• Models use ref() to reference seeds, enabling full dbt workflow testing
• Manifest generation: Removed pre-committed manifest.json; CI now generates it via dbt build to ensure tests validate actual dbt output

CI/CD - End-to-End Workflow

• GitHub Actions workflow dbt-integration-tests.yml
• Runs on Python 3.11 & 3.12
• Triggers on dbt code/test changes
• Uses Makefile for dependency installation (make install-python-dependencies-ci)
• Executes full dbt workflow: dbt deps, dbt build, dbt test with seed data
• Tests Feast CLI integration:
  • Creates Feast project with SQLite online store configuration
  • Runs feast dbt import command with generated manifest
  • Verifies Feast objects (entities, feature views) are created correctly
• Validates both dbt compilation and Feast import work together

Bug Fixes

• Removed deprecated PytestUnhandledCoroutineWarning from pytest.ini
• Fixed test failures by ensuring manifest.json is generated by dbt during CI rather than pre-committed

Test Example

def test_get_models_with_tag_filter(self, parser):
    """Test filtering models by dbt tag."""
    # Filter by 'ml' tag
    ml_models = parser.get_models(tag_filter="ml")
    assert len(ml_models) == 2
    
    # Filter by 'recommendations' tag
    rec_models = parser.get_models(tag_filter="recommendations")
    assert len(rec_models) == 1

Which issue(s) this PR fixes:

Related to #3335

Misc

Comprehensive documentation added for test structure and dbt project. The workflow now provides complete end-to-end testing from dbt model definition through to Feast feature store integration, including actual data materialization to SQLite online store. The manifest.json is dynamically generated during CI to ensure tests validate real dbt compilation output.

• Fixes Add integration tests for dbt import with local dbt project #5869

💬 We'd love your input! Share your thoughts on Copilot coding agent in our 2 minute survey.