microsoft / microsoft/dbt-scope

feat: ML-heuristic based AU assignment that optimizes for processing time

Open
#43 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
3
Forks
4
Avg merge
3d 16h
Merged PRs (30d)
1

Description

  1. We know per table, per .SS file, num rows
  2. We have the user guess the AU to assign, is dumb
  3. We could have a is_au_telemetry_on, which stores AU vs files vs runtime of job
  4. If is_dynamic_au_on is true, we could have some sort of ML model that looks at the microbatch size and look at historical heuristics to figure out the best AU to apply to process the backlog most optimally (but don't overassign)

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the existing AU assignment path and any telemetry or dynamic-AU entry points; the issue names no files or tests. Read how microbatch size, per-file row counts, runtime history, and the overassignment constraint are represented. Done means the dynamic path can use historical heuristics to select an AU for backlog processing without overassigning.

Written by the indexing model from the issue text.

Assessment

Tech stack
machine-learning, python
Domain
data-engineering, machine-learning
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.