write-back-testing

Write test data to source systems and verify connector reads and deletions.

60|116|Updated Nov 13, 2025
One-click install
npx skills add https://github.com/databrickslabs/lakeflow-community-connectors --skill write-back-testing
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: write-back-testing
Source: https://github.com/databrickslabs/lakeflow-community-connectors/tree/main/.claude/skills/write-back-testing
Command: npx skills add https://github.com/databrickslabs/lakeflow-community-connectors --skill write-back-testing

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of writing test data to a source system and then verifying that your connector can correctly read and ingest that data, ensuring end-to-end data pipeline integrity.

Core Features & Use Cases

  • Automated Data Writing: Generates and writes test rows to source systems for specific tables.
  • Read Validation: Confirms that data written to the source can be successfully read back by the connector.
  • Delete Testing: Supports testing the deletion of records for Change Data Capture (CDC) scenarios.
  • Use Case: Before deploying a new data connector, use this Skill to write sample customer records to a CRM, then read them back to ensure the connector accurately captures and transforms the data, including handling deletions.

Quick Start

Run the write-back tests for the 'salesforce' connector.

Frequently Asked Questions about write-back-testing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate end-to-end data flow for a custom connector?

End-to-end data flow validation is done by writing test data to source systems and verifying subsequent reads and deletions. This ensures your connector accurately captures and transforms data before deployment.

How does write-back testing work for connector development?

Write-back testing works by generating test rows and writing them to specific source tables, then confirming the connector reads that data back. It verifies the full ingestion pipeline integrity from source to destination.

Can I test CDC delete operations when validating a data connector?

Yes, you can test CDC delete operations. The testing utilities support Change Data Capture scenarios by writing records to the source and validating that the connector correctly processes subsequent deletions.

Do I need any external dependencies to run automated write-back tests?

No external dependencies are required to run automated write-back tests. The utilities operate independently to write test data to source systems and validate reads without needing additional packages.

What is the best way to verify a connector reads sample CRM records correctly?

The best way to verify a connector reads CRM records correctly is to automate writing sample customer records to the CRM source, then validate the reads and transformations to ensure accurate data pipeline integrity.

Why does my connector read validation fail after writing test data to the source?

Read validation fails when the connector cannot successfully read or ingest the test rows written to the source system. This indicates an issue with how the connector captures or transforms the data end-to-end.