/sap-datasphere

name: sap-datasphere
description: "SAP Datasphere development skill with 3 specialized agents, 5 slash commands, and validation hooks. Use when building data warehouses on SAP BTP, creating analytic models, configuring data flows and replication flows, setting up connections, managing spaces and users, implementing data access controls, using the datasphere CLI, or inspecting authenticated Datasphere browser UI state with Microsoft Edge CDP. Covers Data Builder, Business Builder, analytic models, 40+ connection types, real-time replication, task chains, content transport, and data marketplace."
license: GPL-3.0
metadata:
  maintainer: "Eduard Jiglau"
  maintainer_email: "hello@sap-ai-skills.com"
  website: "https://sap-ai-skills.com"
  version: "2.4.1"
  last_verified: 2026-06-11
  keywords: [sap datasphere, data warehouse cloud, dwc, data builder, business builder, analytic model, graphical view, sql view, transformation flow, replication flow, data flow, task chain, remote table, local table, datasphere connection, datasphere space, data access control, elastic compute node, datasphere cli, data products, data marketplace, catalog, governance, business data cloud, bdc, sap databricks]

SAP Datasphere Skill

Related Skills

• **sap-dependency-security**: Use for secure dependency policy, lockfile hygiene, and exact MCP server pins when managing large connector or integration projects with package-managed tooling

Table of Contents

• [Overview](#overview)
• [Quick Reference](#quick-reference)
• [Core Components](#core-components)
• [Object Types](#object-types)
• [Data Builder](#data-builder)
• [Graphical Views](#graphical-views)
• [SQL Views](#sql-views)
• [Tables](#tables)
• [Flows](#flows)
• [Task Chains](#task-chains)
• [Business Builder](#business-builder)
• [Analytic Models](#analytic-models)
• [Connections](#connections)
• [Space Management](#space-management)
• [Data Access Control](#data-access-control)
• [Monitoring](#monitoring)
• [CLI Reference](#cli-reference)
• [Data Products & Marketplace](#data-products--marketplace)
• [Catalog & Governance](#catalog--governance)
• [Content Transport](#content-transport)
• [Common Issues](#common-issues)
• [Bundled Resources](#bundled-resources)
• [Documentation Links](#documentation-links)

Overview

SAP Datasphere is SAP's cloud-native data warehouse solution on SAP Business Technology Platform (BTP). It serves as the **data foundation** within **SAP Business Data Cloud (BDC)**, SAP's unified data and analytics platform that also includes SAP Analytics Cloud, SAP HANA Cloud, SAP Databricks, and curated data products. See `references/business-data-cloud.md` for the BDC architecture and how Datasphere fits within it.

This skill provides comprehensive guidance for data acquisition, preparation, modeling, administration, and integration.

When to Use This Skill

**Use this skill when**:

• Creating data warehouses on SAP BTP
• Building analytic models for SAP Analytics Cloud
• Setting up data flows, replication flows, or transformation flows
• Configuring connections to SAP or third-party systems
• Managing spaces, users, and access controls
• Implementing real-time data replication
• Monitoring data integration tasks
• Inspecting authenticated Datasphere browser UI state in Microsoft Edge when MCP, CLI, logs, or exported artifacts cannot observe the needed state

For Datasphere browser triage, use the shared `sap-browser-automation` skill for manual in-app authentication, consent-gated authenticated Edge profile copying, fresh loopback CDP startup, target selection, and recovery. The local `references/edge-cdp-control.md` add-on retains Datasphere-specific boundaries. Use CDP for local read-only inspection of Data Builder, Business Builder, monitoring, connection, catalog, and admin UI state; ask before saving, deploying, deleting, importing, exporting, running task chains, or changing users/roles.

---

Quick Reference

Core Components

| Component | Purpose | Key Objects | |-----------|---------|-------------| | **Data Builder** | Data acquisition & preparation | Views, Tables, Flows, Task Chains | | **Business Builder** | Semantic layer modeling | Business Entities, Fact Models, Consumption Models | | **Analytic Model** | Analytics-ready structures | Dimensions, Facts, Measures, Hierarchies | | **Connections** | External data sources | 40+ connection types | | **Spaces** | Logical data containers | Storage, Users, Objects |

Object Types

**Views**:

• Graphical View: Visual data modeling with drag-and-drop
• SQL View: SQL-based view definitions
• Analytic Model: Analytics-optimized semantic layer

**Tables**:

• Local Table: Data stored in Datasphere
• Remote Table: Virtual access to external data
• Local Table (File): Object store-based storage

**Flows**:

• Data Flow: ETL transformations
• Replication Flow: Data replication from sources
• Transformation Flow: Delta-aware transformations

---

Data Builder

Graphical Views

Create views visually by dragging sources and adding transformations.

**Supported Operations**:

• Join: Inner, Left Outer, Right Outer, Full Outer, Cross
• Union: Combine multiple sources
• Projection: Select/rename columns
• Filter: Row-level filtering
• Aggregation: Group by with aggregates
• Calculated Columns: Derived values

**Best Practices**:

• Use input parameters for dynamic filtering
• Apply data access controls for row-level security
• Enable persistence for frequently accessed views
• Use lineage analysis to understand dependencies

For detailed graphical view operations, see `references/graphical-sql-views.md`.

SQL Views

Create views using SQL or SQLScript.

-- Basic SQL View
SELECT
    customer_id,
    customer_name,
    SUM(order_amount) AS total_orders
FROM orders
GROUP BY customer_id, customer_name

**SQLScript Support**:

• Table variables
• Scalar variables
• Control flow (IF, WHILE, FOR)
• Exception handling

For SQL/SQLScript