Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

Query Experience - Get Distinct Values

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

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
45/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
csharp
Domain
api, tooling

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.

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)
Dominant language
C#
Stars
43
Forks
20
Avg merge
6m
Merged PRs (30d)
1

Getting set up

This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.

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.

More from microsoft/DataFactory.MCP

All issues in microsoft/DataFactory.MCP

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.