data-autocleaning

Profile and clean BigQuery and GCS data using Dataplex results.

Updated Jun 5, 2026
One-click install
npx skills add https://github.com/RxFit/hub-overlay --skill data-autocleaning-rxfit
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-autocleaning
Source: https://github.com/RxFit/hub-overlay/tree/main/hub/skills/data-autocleaning
Command: npx skills add https://github.com/RxFit/hub-overlay --skill data-autocleaning-rxfit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires python, bigquery, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates data quality and transformation for pipelines sourced from BigQuery or Google Cloud Storage (GCS), ensuring high-quality data is ingested and transformed efficiently.

Core Features & Use Cases

  • Automated Data Profiling: Performs data profiling on BigQuery or GCS sources to assess quality and identify anomalies.
  • Data Cleaning: Applies best practices for data ingestion, movement, schema mapping, and comprehensive data cleaning.
  • Use Case: For instance, use this Skill to automatically profile and clean data from a BigQuery dataset before loading it into a data warehouse.

Quick Start

Run the data-autocleaning skill on your BigQuery dataset 'my_dataset' to automatically profile and clean the data.

Frequently Asked Questions about data-autocleaning

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

FAQPage Schema
How do I automate data profiling and cleaning for BigQuery datasets?

Automating data profiling and cleaning for BigQuery datasets involves applying schema mapping and transformation rules based on Dataplex profiling results. This process identifies anomalies and ensures high-quality data ingestion efficiently.

What's the best way to apply schema mapping and data transformation rules in GCS pipelines?

Applying schema mapping and data transformation in GCS pipelines requires executing Python scripts that leverage Dataplex profiling results. This approach enforces data quality rules and cleans data before it reaches your data warehouse.

Do I need Python and BigQuery access to run automated data quality checks?

Yes, you need Python and BigQuery access to run automated data quality checks. These dependencies are required to execute the scripts that perform data profiling and apply cleaning rules to your datasets.

Can I use Dataplex profiling results to automatically clean data in Google Cloud Storage?

Yes, you can use Dataplex profiling results to automatically clean data in Google Cloud Storage. The process applies best practices for data movement and cleaning rules directly to sources sourced from GCS.

What is automated data quality profiling for BigQuery and GCS pipelines?

Automated data quality profiling for BigQuery and GCS pipelines is the process of assessing data sources to identify anomalies and apply schema mapping. It ensures high-quality data is ingested and transformed efficiently.