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.

インストールへ移動

リポジトリ: Snowflake-Labs/coco-skills
ソースの最終更新活動: 2026年7月15日 01:22
検出された SKILL.md の言語: 英語
スター: 23
フォーク: 9

インストール方法

デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。

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

コマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。

ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。

ソースファイルを確認

インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。

ファイルエクスプローラー

12 ファイル

SKILL.md

ソースの指示 · 読み取り専用プレビュー

検索に戻るインストールに戻る

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

このリポジトリのすべてを見る

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

インストール方法

ソースファイルを確認

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

ソース情報

インストール方法

ソースファイルを確認

このリポジトリの他の Skills

SAP BDC <=> Snowflake Zero-Copy Integration

When to Use

Prerequisites

Workflow

Step 1: Ask User Intent

Connector Quick Reference

Connector States

このリポジトリの他の Skills

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