skills.rest
MarioDeFelipe
MarioDeFelipeCOMMUNITY
Explore all skills by this author →
GitHub

Transformation Logic Generator

Generate and validate SAP Datasphere transformation logic using SQLScript and Python operators.

25|7|Updated Feb 7, 2026
Search Tags:#python#etl#performance-optimization#sap-datasphere#scd-type-2#sqlscript#delta-loading
One-click install
npx skills add https://github.com/MarioDeFelipe/sap-datasphere-plugin-for-claude-cowork --skill transformation-logic-generator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Transformation Logic Generator
Source: https://github.com/MarioDeFelipe/sap-datasphere-plugin-for-claude-cowork/tree/main/skills/datasphere-transformation-logic
Command: npx skills add https://github.com/MarioDeFelipe/sap-datasphere-plugin-for-claude-cowork --skill transformation-logic-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Building reliable, maintainable, and performant transformation logic for SAP Datasphere can be time-consuming and error-prone; this Skill removes guesswork by providing proven SQLScript and Python patterns, delta handling strategies, and validation steps to reduce runtime failures and data quality issues.

Core Features & Use Cases

  • SQLScript patterns: MERGE upserts, watermark-based delta loads, CTEs, window functions, partitioning, and SCD Type 2 templates for Transformation Flows.
  • Python operator recipes: pandas-style fusion, chunked processing for large datasets, custom business logic, and memory management for Data Flows.
  • Testing & diagnostics: sample execute_query and smart_query checks, schema inspection with get_table_schema, distribution analysis, and structured logging/error handling patterns.
  • Use cases: incremental ETL pipelines, SCD Type 2 dimension management, deduplication and pivoting workflows, CDC integration, and performance tuning for million-row workloads.

Quick Start

Ask the skill to generate a MERGE-based SQLScript procedure implementing SCD Type 2 with watermark delta handling and include validation queries and logging.

Frequently Asked Questions about Transformation Logic Generator

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

FAQPage Schema
How do I generate SQLScript for incremental delta loads in SAP Datasphere?▼

Generate SCD Type 2 logic in SAP Datasphere by applying SQLScript templates to Transformation Flows. These patterns manage historical dimension records by tracking effective dates and active status within the data warehouse.

Can I use Python operators for data transformations in SAP Datasphere Data Flows?▼

Use Python operators in SAP Datasphere Data Flows to apply pandas-style DataFrame fusion and custom business logic. This supports chunked processing for large datasets and memory management for million-row workloads.

What is the best way to validate transformation logic before running production ETL pipelines?▼

Validate transformation logic by running sample execute_query and smart_query checks before production deployment. This process inspects schemas with get_table_schema, analyzes data distribution, and ensures robust error handling for reliable workloads.

How do I optimize SAP Datasphere performance for million-row transformation workloads?▼

Optimize SAP Datasphere performance for million-row workloads by applying SQLScript partitioning, CTEs, and window functions. Python operators also provide chunked processing and memory management to tune large data transformations.

Does this approach handle deduplication and pivoting in SAP Datasphere?▼

Yes, this approach handles deduplication and pivoting workflows in SAP Datasphere. It generates SQLScript and Python transformation logic within Transformation Flows to restructure datasets and remove duplicate records effectively.

Related Skills

Explore More Data & Analytics Skills→
MarioDeFelipeMarioDeFelipe
25

datasphere-data-flows

Orchestrate SAP Datasphere replication, transformation, and task chain flows.

Community
Advanced
m19cm19c

databricks-spark-declarative-pipelines

Automates creation, configuration, and management of Databricks Lakeflow Spark Declarative Pipelines.

Community
Advanced
erichowenserichowens
181

data-pipeline-engineer

Automate ETL/ELT pipeline design, validation, and operation across medallion architectures.

Community
Advanced
MarioDeFelipeMarioDeFelipe
25

SAP Datasphere Business Content Activator

Activate SAP Business Content packages in Datasphere with prerequisite checks and conflict resolution.

Community
Advanced