| name | manage-zerocopy-sapbdc |
| description | >- |
Manages the full lifecycle of the SAP BDC <=> Snowflake zero-copy integration and connector: setup, consume, publish, analyze, and troubleshoot.
CREATE ZEROCOPY CONNECTOR on the target schemaCREATE SHARE privilege on the accountEvery 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:
create-connector/INSTRUCTIONS.mdconsume/INSTRUCTIONS.mdpublish/INSTRUCTIONS.mdanalyze/INSTRUCTIONS.mdtroubleshoot/INSTRUCTIONS.md| 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 |
| 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('<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 |
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 Partner ID for SAP 4 Me registration, then connects with invitation link.
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.
User: $manage-zerocopy-sapbdc publish my ANALYTICS_DB.SALES schema to SAP BDC
Assistant: Enables share-back, creates Iceberg tables, generates CSN Interop JSON, creates share, publishes data product.
User: $manage-zerocopy-sapbdc my connector is stuck in CONNECT_ERROR
Assistant: Runs DESC ZEROCOPY CONNECTOR, checks privileges, validates invitation link, provides remediation steps.
Depends on selected use case — see sub-skill outputs.
Use when running a Snowflake Well-Architected Framework (WAF) assessment for a customer account. Three-tier scale: On Track / Needs Improvement / Needs Attention. Results displayed inline; optional HTML export. Triggers: WAF assessment, well-architected, architecture review, WAF review, security assessment, pillar assessment, security and governance, reliability, cost optimization, operational excellence, performance.
Use when a contributor has built a Cortex Code skill locally and wants a pre-PR readiness check before opening a pull request against Snowflake-Labs/cortex-code-skills. Verdict: promote, adapt, or skip — with concrete fixes. Triggers: "review a skill", "is this skill ready for labs", "check this skill before PR", "audit skill for promotion", "does this skill belong in labs".
Use for ALL requests to install, set up, deploy, or tear down a pre-built Snowflake industry solution. This skill reads a solution's manifest.json for metadata, then executes its setup SQL scripts against the user's Snowflake account. Triggers: install solution, coco solutions install, set up solution, deploy solution, teardown solution, uninstall solution, sf-solutions, solution accelerator, demo environment. Do NOT use for: adding pages to the solutions catalog website (use snowflake-solutions-catalog instead), building custom solutions from scratch, or general SQL authoring.
Use when designing or operating Snowpipe disaster recovery on Azure ADLS Gen2 — choosing between dual-pipe, RA-GRS, active-active, or Failover Group patterns, and running failover/failback/catchup. Triggers: snowpipe BCDR, snowpipe disaster recovery, snowpipe failover, dual pipe, active-active pipe, RA-GRS snowpipe, GZRS snowpipe, snowpipe catchup, pipe failback, snowpipe high availability, failover group snowpipe, snowpipe RPO RTO.
Use when a developer or data engineer wants to assess MLOps maturity, design a promotion strategy (Code/Model/Hybrid), or implement MLOps capabilities (CI/CD, monitoring, retraining, governance) on Snowflake for traditional ML or LLM/GenAI workloads. Triggers: mlops, mlops maturity, mlops assessment, mlops strategy, mlops pattern, mlops framework, model promotion, ml ci/cd, ml monitoring, llmops, rag pipeline ops, fine-tuning ops.
Use when migrating a Snowflake Data Clean Room from V1 (SAMOOHA Provider/Consumer API) to V2 (Collaboration API). Discovers V1 setup via introspection queries, maps constructs to Collaboration API equivalents, converts JinjaSQL templates, and generates provider/consumer setup plus cleanup scripts. Output is local files only — no live DDL/DML. Triggers: DCR migration, V1 to V2, clean room upgrade, clean room migration, migrate DCR, upgrade clean room, SAMOOHA to Collaboration API.