microsoft / microsoft/DataFactory.MCP
Query Experience - Get Distinct Values
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 42
- Forks
- 19
- PR merge metrics
- No merged PRs in 30d
Description
Issue: Add get_distinct_values tool
Labels: enhancement, query-experience, priority:medium
Problem:
Exploring filter values (e.g., "what categories exist?") requires custom queries each time.
Proposed Solution:
Tool to get distinct values for a column, with optional count.
Acceptance Criteria:
- Tool accepts: dataflow ID, table name, column name, limit (default 100)
- Returns distinct values with optional frequency count
- Sorted by frequency or alphabetically (configurable)
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the repository's existing query tools and their tests to understand how dataflow IDs, tables, columns, limits, and result options are handled. Add the distinct-values tool with optional counts and configurable frequency or alphabetical ordering, then verify all acceptance criteria through the relevant test suite.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- api, tooling
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100