| 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
