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). Triggers: SAP BDC, SAP connector, minimal CSN, SDK CSN, zerocopy connector, SAP data product, SAP BDC Connect, SAP publish, SAP share, SAP troubleshoot.

Jump to install

Repository: Snowflake-Labs/coco-skills
Last source activity: July 15, 2026 at 01:22
Detected SKILL.md language: English
Stars: 23
Forks: 9

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/Snowflake-Labs/coco-skills --skill manage-zerocopy-sapbdc

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

12 files

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

deploy-code-bundle

Deploy a migrated Snowpark/SCOS project to Snowflake as a Code Bundle. Takes the migrated project (its .py entrypoint + supporting modules/config), reminds the user to fix flagged code, writes a code_bundle.yml spec, uploads the whole project to a Snowflake stage, and creates the Code Bundle from the stage — on a warehouse (default) or a compute pool. No .ipynb is involved. Triggers: deploy code bundle, deploy to code bundle, run as code bundle, create code bundle from migration output, execute code bundle, snow bundle.

2026-08-21

deploy-notebook

Deploy a migrated Snowpark/SCOS project to Snowflake as a Notebook. Takes the .ipynb produced by the migration skill (plus its supporting project files), reminds the user to fix flagged code, uploads the whole project to a Snowflake stage, and creates the Notebook from the stage. Triggers: deploy notebook, deploy migrated notebook, create notebook from migration output, upload project to stage, deploy scos notebook, deploy snowpark notebook.

2026-08-21

spark-migration

Migrate Spark scripts and notebooks to Snowflake. Routes to one of two bundled conversion paths and orchestrates the post-conversion pipeline. **Default path: Snowpark Connect (SCOS)**, which preserves the PySpark API surface. The SMA / Snowpark API path is invoked only when the user explicitly asks for it. Also **deploys** the output as a **Notebook** (`deploy-notebook`) or **Code Bundle** (`deploy-code-bundle`). Triggers: convert spark, migrate pyspark, migrate spark, migrate to snowpark, convert to snowpark, snowpark connect, scos, scos migration, migrate to snowpark connect, migrate to scos, snowpark api, sma cli, sma conversion, run sma, snowflake.snowpark rewrite, already migrated, already ran sma, sma dashboard, fix ewis, stage conversion, dvp orchestrator, resume dvp, assess pyspark, assess spark, assess databricks, spark assessment, databricks assessment, spark workload assessment, migration readiness, migration readiness report, spark readiness, spark compatibility, spark compatibility report, pyspa

2026-08-21

View all from this repository

name	manage-zerocopy-sapbdc
title	SAP BDC Zero-Copy Connector (Minimal CSN)
summary	Manage the lifecycle of the SAP BDC zero-copy connector with minimal CSN generation (SDK-compatible, no validation loops).
description	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). Triggers: SAP BDC, SAP connector, minimal CSN, SDK CSN, zerocopy connector, SAP data product, SAP BDC Connect, SAP publish, SAP share, SAP troubleshoot.
tools	["snowflake_sql_execute","snowflake_object_search","Bash","Read","Write","Edit","Glob","Grep"]
prompt	$manage-zerocopy-sapbdc create a connector and publish with minimal CSN
language	en
status	Custom
author	Amit Tapas & Kevin Poskitt
type	snowflake

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

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

Command	Purpose
`CREATE ZEROCOPY CONNECTOR <name> PARTNER = SAP_BDC`	Create connector
`SELECT CURRENT_ORGANIZATION_NAME() \|\| '-' \|\| CURRENT_ACCOUNT_NAME()`	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$ZEROCOPY_CONNECTOR_LIST_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/CONNECT_ERROR/DISCONNECT_ERROR/DISCONNECTED)

Privilege	Scope	Purpose
CREATE ZEROCOPY CONNECTOR	Schema	Create connector
OPERATE	Connector	Connect, disconnect, and publish data product (SYSTEM$SAP_PUBLISH_DATA_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

manage-zerocopy-sapbdc

Install options

Review the source files

SAP BDC <=> Snowflake Zero-Copy Integration

When to Use

Prerequisites

Workflow

Step 1: Ask User Intent

Connector Quick Reference

Connector States

SAP BDC <=> Snowflake Zero-Copy Integration

When to Use

Prerequisites

Workflow

Step 1: Ask User Intent

Connector Quick Reference

Connector States

Key SQL Commands

Required Privileges

Examples

Example 1: Create and enroll a connector

Example 2: Consume a data product

Example 3: Publish Snowflake data to SAP

Example 4: Troubleshoot

Stopping Points

Output

manage-zerocopy-sapbdc

Source facts

Install options

Review the source files

More from this repository

More from this repository

SAP BDC <=> Snowflake Zero-Copy Integration

When to Use

Prerequisites

Workflow

Step 1: Ask User Intent

Connector Quick Reference

Connector States

SAP BDC <=> Snowflake Zero-Copy Integration

When to Use

Prerequisites

Workflow

Step 1: Ask User Intent

Connector Quick Reference

Connector States

Key SQL Commands

Required Privileges

Examples

Example 1: Create and enroll a connector

Example 2: Consume a data product

Example 3: Publish Snowflake data to SAP

Example 4: Troubleshoot

Stopping Points

Output