Related Issues/PRs

Towards #19515

What changes are proposed in this pull request?

Rest API/Python API for deleting dataset records for SQL based backends

How is this PR tested?

• Existing unit/integration tests
• New unit/integration tests
• Manual tests

Rest API/Python API for deleting dataset records for SQL based backends

Code:

import mlflow
from mlflow import MlflowClient

mlflow.set_tracking_uri("http://localhost:5000")
client = MlflowClient()

experiment_name = "simple_dataset_demo"
experiment = mlflow.get_experiment_by_name(experiment_name)
if experiment is None:
    experiment_id = mlflow.create_experiment(experiment_name)
else:
    experiment_id = experiment.experiment_id

dataset = client.create_dataset(
    name="simple_qa_dataset",
    experiment_id=[experiment_id],
)
print(f"Created dataset: {dataset.dataset_id}")

records = [
    {"inputs": {"question": "What is MLflow?"}, "expectations": {"answer": "ML platform"}},
    {"inputs": {"question": "What is Python?"}, "expectations": {"answer": "A language"}},
    {"inputs": {"question": "What is Docker?"}, "expectations": {"answer": "Containers"}},
]
dataset.merge_records(records)
print(f"Added {len(records)} records")

dataset = client.get_dataset(dataset.dataset_id)
df = dataset.to_df()
record_ids = df["dataset_record_id"].tolist()
print(f"Records in dataset: {len(record_ids)}")

# Use the new entity method instead of client method
deleted_count = dataset.delete_records([record_ids[0]])
print(f"Deleted {deleted_count} record")

dataset = client.get_dataset(dataset.dataset_id)
df_after = dataset.to_df()
print(f"Records remaining: {len(df_after)}")

Result:

Created dataset: d-6cbefb17c9d1439ab65ea338e0aea087
Added 3 records
Records in dataset: 3
Deleted 1 record
Records remaining: 2

Does this PR require documentation update?

• No. You can skip the rest of this section.
• Yes. I've updated:
  • Examples
  • API references
  • Instructions

Release Notes

Is this a user-facing change?

• No. You can skip the rest of this section.
• Yes. Give a description of this change to be included in the release notes for MLflow users.

Rest API/Python API for deleting dataset records for SQL based backends

What component(s), interfaces, languages, and integrations does this PR affect?

Components

• area/tracking: Tracking Service, tracking client APIs, autologging
• area/models: MLmodel format, model serialization/deserialization, flavors
• area/model-registry: Model Registry service, APIs, and the fluent client calls for Model Registry
• area/scoring: MLflow Model server, model deployment tools, Spark UDFs
• area/evaluation: MLflow model evaluation features, evaluation metrics, and evaluation workflows
• area/gateway: MLflow AI Gateway client APIs, server, and third-party integrations
• area/prompts: MLflow prompt engineering features, prompt templates, and prompt management
• area/tracing: MLflow Tracing features, tracing APIs, and LLM tracing functionality
• area/projects: MLproject format, project running backends
• area/uiux: Front-end, user experience, plotting, JavaScript, JavaScript dev server
• area/build: Build and test infrastructure for MLflow
• area/docs: MLflow documentation pages

How should the PR be classified in the release notes? Choose one:

• rn/none - No description will be included. The PR will be mentioned only by the PR number in the "Small Bugfixes and Documentation Updates" section
• rn/breaking-change - The PR will be mentioned in the "Breaking Changes" section
• rn/feature - A new user-facing feature worth mentioning in the release notes
• rn/bug-fix - A user-facing bug fix worth mentioning in the release notes
• rn/documentation - A user-facing documentation change worth mentioning in the release notes

Should this PR be included in the next patch release?

Yes should be selected for bug fixes, documentation updates, and other small changes. No should be selected for new features and larger changes. If you're unsure about the release classification of this PR, leave this unchecked to let the maintainers decide.

• Yes (this PR will be cherry-picked and included in the next patch release)
• No (this PR will be included in the next minor release)