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.

Aller à l'installation

Dépôt: Snowflake-Labs/coco-skills
Dernière activité de la source: 15 juillet 2026 à 01:22
Langue détectée de SKILL.md: anglais
Étoiles: 23
Forks: 9

Options d'installation

Le prompt qui vérifie d'abord la source est sélectionné par défaut. Vous pouvez passer à une commande directe ou télécharger une copie locale.

Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.

Une commande directe contourne le prompt de vérification. Examinez la source avant de l'exécuter.

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

La commande reste sur une seule ligne. Faites défiler horizontalement pour la vérifier avant de la copier.

Vous préférez une copie locale ? Téléchargez les fichiers actuellement disponibles dans SkillsMP.

Vérifiez les fichiers source

Lisez SKILL.md et les fichiers associés affichés par SkillsMP avant de décider de l'installer.

Explorateur de fichiers

12 fichiers

SKILL.md

Instructions source · Aperçu en lecture seule

Retour à la recherche Retour à l’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

Tout voir dans ce dépôt

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

Options d'installation

Vérifiez les fichiers source

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

Informations de source

Options d'installation

Vérifiez les fichiers source

Plus depuis ce dépôt

SAP BDC <=> Snowflake Zero-Copy Integration

When to Use

Prerequisites

Workflow

Step 1: Ask User Intent

Connector Quick Reference

Connector States

Plus depuis ce dépôt

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