AI Builder App 배포 핸즈온

┌────────────────────────────────────────────┐
│   Builder App (mcp-builder-app)            │
│                                             │
│   브라우저 접속 → Builder 웹 UI              │
│   Genie Code 연결 → MCP 서버 (/mcp)         │
└────────────────────────────────────────────┘

# AI Dev Kit 클론
git clone https://github.com/databricks-solutions/ai-dev-kit.git
cd ai-dev-kit/databricks-builder-app

# Builder App + MCP 서버 배포
./scripts/deploy.sh mcp-builder-app --enable-mcp --profile <PROFILE>

# CLI 설치 확인
databricks --version

# 인증
databricks auth login --host https://<your-workspace-url>
databricks current-user me

git clone https://github.com/databricks-solutions/ai-dev-kit.git
cd ai-dev-kit

databricks apps create mcp-builder-app \
  --description "AI Dev Kit Builder App with MCP"

DBUSER=$(databricks current-user me | jq -r .userName)
APP_PATH="/Workspace/Users/$DBUSER/mcp-builder-app"

databricks workspace mkdirs "$APP_PATH"

# Builder App 소스 업로드
for f in databricks-builder-app/app/*; do
  [ -f "$f" ] || continue
  databricks workspace import "$APP_PATH/$(basename $f)" \
    --file "$f" --format RAW --overwrite
done

# 배포
databricks apps deploy mcp-builder-app --source-code-path "$APP_PATH"
databricks apps get mcp-builder-app

# SP 정보 확인
SP_CLIENT_ID=$(databricks apps get mcp-builder-app -o json | jq -r .service_principal_client_id)
SP_ID=$(databricks apps get mcp-builder-app -o json | jq -r .service_principal_id)

# 엔타이틀먼트 부여
databricks api patch /api/2.0/preview/scim/v2/ServicePrincipals/$SP_ID --json '{
  "schemas": ["urn:ietf:params:scim:api:messages:2.0:PatchOp"],
  "Operations": [{"op": "add", "value": {
    "entitlements": [
      {"value": "allow-cluster-create"},
      {"value": "workspace-access"},
      {"value": "databricks-sql-access"}
    ]
  }}]
}'

-- 카탈로그 권한 (노트북에서 실행)
GRANT ALL PRIVILEGES ON CATALOG lge_smart_tv TO `<sp_client_id>`;

# SQL Warehouse 권한
WH_ID="<your_warehouse_id>"
TOKEN=$(databricks auth token | jq -r .access_token)
HOST=$(databricks auth env | jq -r .env.DATABRICKS_HOST)

curl -X PATCH "$HOST/api/2.0/permissions/warehouses/$WH_ID" \
  -H "Authorization: Bearer $TOKEN" \
  -H "Content-Type: application/json" \
  -d "{\"access_control_list\": [{
    \"service_principal_name\": \"$SP_CLIENT_ID\",
    \"permission_level\": \"CAN_USE\"
  }]}"

# Skills를 Workspace에 업로드
TARGET="/Workspace/.assistant/skills"
for skill_dir in databricks-skills/*/; do
  skill_name=$(basename "$skill_dir")
  [ "$skill_name" = "TEMPLATE" ] && continue
  databricks workspace mkdirs "$TARGET/$skill_name"
  for f in "$skill_dir"*; do
    [ -f "$f" ] || continue
    databricks workspace import "$TARGET/$skill_name/$(basename $f)" \
      --file "$f" --format RAW --overwrite
  done
  echo "✓ $skill_name"
done

# 앱 상태 확인
databricks apps get mcp-builder-app

# 앱 URL 확인 (Builder 웹 UI)
databricks apps get mcp-builder-app -o json | jq -r .url