SkillsAdd

snowflake-labs/coco-skills · Archived

manage-zerocopy-sapbdc

>- Manage the end-to-end lifecycle of the Snowflake and SAP BDC Zero-Copy Integration and connector. Use when: consuming SAP data products in Snowflake, publishing Snowflake databases to SAP BDC with minimal CSN (v1.0, SDK-compatible), analyzing shared SAP data, or troubleshooting SAP BDC connector issues. This version uses MINIMAL CSN generation only (no options, no reviews, no validation loops). SAP data product, SAP BDC Connect, SAP publish, SAP share, SAP troubleshoot.

First seen Aug 6, 2026

Installation

$ npx skills add snowflake-labs/coco-skills --skill manage-zerocopy-sapbdc
View on skills.sh ↗ GitHub repository ↗

Stronger alternatives

This repository is archived — consider an actively maintained alternative.

snowflake-docs Same source · more installs
snowflake-labs/coco-skills

Use for **ALL** Snowflake documentation lookups: feature questions, SQL syntax, best practices,…

15 installs
ontology-stack-builder Same source · more installs
snowflake-labs/coco-skills

>- Use for ALL requests that mention: ontology, knowledge graph, semantic layer from schema, on…

14 installs
semantic-view-patterns Same source · more installs
snowflake-labs/coco-skills

Use when learning Snowflake Semantic View patterns, teaching SV concepts, applying patterns to …

12 installs
mlops Same source · more installs
snowflake-labs/coco-skills

Use when a developer or data engineer wants to assess MLOps maturity, design a promotion strate…

12 installs

Also in this package

Other skills from snowflake-labs/coco-skills · top by installs.

npx skills add snowflake-labs/coco-skills
snowflake-docs 15 ontology-stack-builder 14 semantic-view-patterns 12 mlops 12 rbac 9 setup-openflow-privatelink 8 review-skill-sflabs 8 well-architected-framework-assessment 7 spec-driven 7 solutions-installer 7

Browse all from snowflake-labs/coco-skills

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Stars 29
Default branch main
Open issues 2
Status Archived

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 6,902 B
  • docs README.md 16,990 B
  • docs SUMMARY.md 580 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 2 installs

SKILL.md

SAP BDC <=> Snowflake Zero-Copy Integration

Manages the full lifecycle of the SAP BDC <=> Snowflake zero-copy integration and connector: setup, consume, publish, analyze, and troubleshoot.

When to Use

  • User asks to create, connect, or enroll an SAP BDC zero-copy connector
  • User wants to consume or mount SAP BDC shared data products in Snowflake
  • User wants to publish Snowflake data back to SAP BDC as a data product
  • User asks to explore, query, or join data from mounted SAP data products
  • User needs to troubleshoot SAP BDC connector states, privileges, or connectivity
  • Do NOT use for: general Snowflake data sharing (non-SAP), SAP HANA direct connections, or SAP BTP non-BDC services

Prerequisites

  • An ORGADMIN must have accepted the SAP® BDC Connect for Snowflake Terms (Admin » Terms » Snowflake Marketplace section in Snowsight). This only needs to be done once per Snowflake organization.
  • SAP Business Data Cloud (BDC) setup must be complete
  • Role must have CREATE ZEROCOPY CONNECTOR on the target schema
  • For publishing: CREATE SHARE privilege on the account

Workflow

Step 1: Ask User Intent

Every time this skill is invoked, present this menu:

What would you like to do with the SAP BDC <=> Snowflake zero-copy connector?

1. Create a new zero-copy connector - Set up a new connector and enroll it with SAP BDC
2. Consume shared data products - Mount shared SAP BDC data products as catalog-linked databases in Snowflake
3. Publish a data product - Share a Snowflake database back to SAP BDC as a new data product
4. Analyze shared data - Explore, query, and join data from SAP BDC data products already mounted in Snowflake
5. Troubleshoot - Diagnose and fix connector state errors, privilege issues, and connectivity problems

Route based on selection:

  • Option 1 -> Load create-connector/INSTRUCTIONS.md
  • Option 2 -> Load consume/INSTRUCTIONS.md
  • Option 3 -> Load publish/INSTRUCTIONS.md
  • Option 4 -> Load analyze/INSTRUCTIONS.md
  • Option 5 -> Load troubleshoot/INSTRUCTIONS.md

Connector Quick Reference

Connector States

State Description Allowed Actions
NEW Just created, no connection attempted CONNECT, DROP
CONNECTING Connection in progress (async) Wait
CONNECTED Active connection DISCONNECT (must disable share-back and drop CLDs first), create CLDs, publish
CONNECT_ERROR Connection failed CONNECT (retry), DROP
DISCONNECTING Disconnection in progress (async) Wait
DISCONNECTED Connection dropped CONNECT (reconnect), DROP
DISCONNECT_ERROR Disconnection failed DISCONNECT (retry), DROP
DELETED Connector has been dropped (permanent, no UNDROP) None

Key SQL Commands

Command Purpose
CREATE ZEROCOPY CONNECTOR <name> PARTNER = SAP_BDC Create connector
`SELECT CURRENTORGANIZATIONNAME() \ \ '-' \ \ CURRENTACCOUNTNAME()` Derive account URL for SAP for Me registration
ALTER ZEROCOPY CONNECTOR <name> CONNECT WITH CONFIG = (INVITATION_LINK = '...') Establish connection
DESC ZEROCOPY CONNECTOR <name> Check connector state
SHOW ZEROCOPY CONNECTORS IN SCHEMA <db>.<schema> List all connectors
SELECT SYSTEM$ZEROCOPYCONNECTORLIST_SHARES('<db>.<schema>.<connector>') List available SAP data products
ALTER ZEROCOPY CONNECTOR <name> SET SHARE_BACK = TRUE Enable publishing
ALTER ZEROCOPY CONNECTOR <name> ADD SHARE <share> Associate share for publishing
ALTER ZEROCOPY CONNECTOR <name> DISCONNECT Disconnect (disable share-back and drop CLDs first)
DROP ZEROCOPY CONNECTOR <name> Drop connector (must be NEW/CONNECTERROR/DISCONNECTERROR/DISCONNECTED)

Required Privileges

Privilege Scope Purpose
CREATE ZEROCOPY CONNECTOR Schema Create connector
OPERATE Connector Connect, disconnect, and publish data product (SYSTEM$SAPPUBLISHDATA_PRODUCT)
USAGE Connector Create CLD (also requires CREATE DATABASE on account), add/remove share (also requires OWNERSHIP on share)
MODIFY Connector Set/unset properties (comment, share_back, etc.)
MONITOR Connector Describe connector, show connectors, list shares (any privilege on the connector is sufficient)
OWNERSHIP Connector Rename or drop the connector
CREATE DATABASE Account Create catalog-linked database (also requires USAGE on connector)
CREATE SHARE Account Publish data back to SAP BDC

Examples

Example 1: Create and enroll a connector

User: $manage-zerocopy-sapbdc create a new zero-copy connector and enroll it with SAP BDC Assistant: Asks for database/schema/connector name, runs CREATE ZEROCOPY CONNECTOR, provides the account URL for SAP for Me registration, then connects with invitation link.

Example 2: Consume a data product

User: $manage-zerocopy-sapbdc mount the Workforce Persons data product from SAP Assistant: Lists available shares, creates a catalog-linked database, confirms tables are accessible and semantic views are generated.

Example 3: Publish Snowflake data to SAP

User: $manage-zerocopy-sapbdc publish my ANALYTICS_DB.SALES schema to SAP BDC Assistant: Enables share-back, validates Iceberg V3 tables, generates MINIMAL CSN Interop v1.0 (SDK-compatible, no options, no reviews), creates share, publishes data product.

Example 4: Troubleshoot

User: $manage-zerocopy-sapbdc my connector is stuck in CONNECT_ERROR Assistant: Runs DESC ZEROCOPY CONNECTOR, checks privileges, validates invitation link, provides remediation steps.

Stopping Points

  • After Step 1: Route to selected sub-skill

Output

Depends on selected use case — see sub-skill outputs.