Przejdź do treści
Biblioteka skilli
Dane i analityka · Konwersja i formaty

snowflake-clone-notebook

/snowflake-clone-notebook

Tworzy offline notatnik z tworzeniem schematów, tabel i widoków dla katalogu Standard AIDP, z weryfikacją każdego obiektu.

Licencja
UPL-1.0
Ostatnia zmiana repozytorium
26.10.2026

Ocena i bezpieczeństwo

100/ 100Klasa: dobry
Format25 / 25
Frontmatter z nazwą i opisem, poprawna nazwa, opis do 1024 znaków, nazwa zgodna z folderem.
Odkrywalność25 / 25
Opis mówi, kiedy użyć skilla, ma sensowną długość i jest w 3. osobie.
Treść35 / 35
Co najmniej 150 słów i do 500 linii, nagłówki, listy kroków, przykłady albo kod.
Higiena15 / 15
Bez zaślepek typu TODO, bez ścieżek Windows, z licencją.
Ryzykobrak sygnałów w skanie
Pliki w paczce
1
Skrypty
0
Komentarze HTML
0
Adresy URL w SKILL.md
0
Przestarzałość

Brak sygnałów. Repozytorium zmienione 26.10.2026, bez odwołań do wycofanych modeli i API.

Licencja

UPL-1.0, otwarta.

Co robi i kiedy

Tworzy offline notatnik z tworzeniem schematów, tabel i widoków dla katalogu Standard AIDP, z weryfikacją każdego obiektu.

Oryginalny opis (EN)

Generate the table-creation script for a Standard AIDP catalog as an executable notebook, locally and offline. --upload is a dry run and is refused with --execute; the structure itself is created by the snowmig_01_structure workflow at S10. The script creates schemas, then tables, then views in dependency order, prints per-object progress with elapsed time so a long run stays visible, and verifies each object individually at the end. This script creates structure only and copies no data - every table arrives with zero rows; rows are copied only by the snowmig_02_copy_schema job, when the opera

Jak działa

  1. 1. Generate (offline, safe)
  2. 2. --upload — a dry run, refused with --execute
  3. 3. Execution is the user's call
  4. What the notebook does and does not do
Sekcje z nagłówków SKILL.md, w oryginale · 74 linii, 499 słów
Podgląd SKILL.md
---
name: snowflake-clone-notebook
description: Generate the table-creation script for a Standard AIDP catalog as an executable notebook, locally and offline. --upload is a dry run and is refused with --execute; the structure itself is created by the snowmig_01_structure workflow at S10. The script creates schemas, then tables, then views in dependency order, prints per-object progress with elapsed time so a long run stays visible, and verifies each object individually at the end. This script creates structure only and copies no data - every table arrives with zero rows; rows are copied only by the snowmig_02_copy_schema job, when the operator runs it. Use when the user has explicitly asked for a Standard catalog, or wants the migration delivered as a runnable script rather than executed straight from the CLI.
---

# Standard-catalog table-creation script

**This is the Standard-catalog path, and only for a Standard catalog the user
explicitly asked for.** The default target is an EXTERNAL/SNOWFLAKE catalog,
which needs no tables at all — see `snowflake-medallion-clone` Phase A. Do not
reach for this skill just because a migration is in progress.

Why a script on compute: it runs **inside AIDP compute**, so every
statement's success, failure and elapsed time appears in the cluster's own
output, and each object is read back. The control-plane catalog API is used
for the catalog container only.

Generate locally. `notebook --upload` is a dry run and is refused with
`--execute`; the structure is created by `run --job snowmig_01_structure`
(S10).

**The script creates empty structure and moves no data.** Every table it
creates has its columns and zero rows. A user who hears "clone" may expect rows —
say this before they run it.

## 1. Generate (offline, safe)

```bash
"${CLAUDE_PLUGIN_ROOT}/bin/snowmig" notebook \
  [--catalog <catalog>]
```

Writes `snowmig_shallow_clone_<catalog>.ipynb` locally plus `NOTEBOOK.md`.
One notebook per catalog — bronze mirrors the source, so a multi-database estate
has several.

## 2. `--upload` — a dry run, refused with `--execute`

```bash
"${CLAUDE_PLUGIN_ROOT}/bin/snowmig" notebook \
  --upload --datalake-ocid <ocid> --workspace <ws> --cluster-id <cl> --catalog <cat>
```

`--upload` is a **dry run** without `--execute`: it prints where the notebook
would land and sends nothing. With `--execute` the upload is **refused**, and
the command says so. The structure is created by `snowmig provision --execute`
(which places the stage notebooks in the workspace) followed by `snowmig run
--job snowmig_01_structure` (S10). Ask the user for the four coordinates in
this turn; nothing is stored.

Nothing lands there from this command. `NOTEBOOK.md` records
`/Workspace/Shared/snowmig_shallow_clone_<catalog>.ipynb` as the intended
path, and if the user places it there themselves from the workspace UI, the
**shared** directory is the right home — re-runnable, readable and debuggable
independently of this plugin and of the conversation that generated it.
**Notebooks live in the workspace filesystem, not in a data catalog** — catalogs
hold tables and views. Say that if the user expects to find it under a catalog.

## 3. Execution is the user's call

**Do not run it for them.** Ask, then let them run it in the AIDP workspace
after they agree.

The notebook is built to be watched: each object prints
`[3/7] D.S.ORDERS ... ok (0.4s)`. If a run is slow, that output is where the
progress is — report the last line rather than guessing. The final cell prints
`verified N/M` plus any missing object.

## What the notebook does and does not do

- Creates schemas → tables → views, in that order, views after the tables they read
- `IF NOT EXISTS` throughout, so re-running is safe
- **No `INSERT`, `COPY INTO`, `MERGE`, `UPDATE`, `DELETE`, `TRUNCATE` or `DROP`.**
  Its metadata records `moves_data: false`
- Tables arrive **empty**. Say this out loud — a user seeing "clone" may expect rows
- Blocked objects appear in markdown only, never in a code cell, so it cannot
  attempt them

Wersje

RepozytoriumWynikLicencja
Ta strona · oracle-samples/oracle-aidp-samples100UPL-1.0
oracle-samples/oracle-aidp-samples100UPL-1.0

Migawka bazy z 13.11.2026 · wersja paczki 96bd4754a278 (skrót SHA-256 całej paczki)

Pobrania w ostatnich 30 dniach: 0 · ranking

Zgłoś problem z tym skillem: szkodliwa treść, błędny opis albo prośba autora o usunięcie.

Podobne skille

  • 100snowflake-medallion-clone
    Tworzy architekturę medallion w AIDP: rejestruje katalog zewnętrzny i generuje SQL dla schematów, tabel i widoków.
  • 100snowflake-medallion-clone
    Buduje strukturę medallion w AIDP z zatwierdzonego planu Snowflake, bez kopiowania danych na tym etapie.
  • 100snowflake-explore
    Odkrywa bazy, schematy, tabele, widoki i kolumny w Snowflake, by zrozumieć dostępne dane i ich strukturę.
  • 96write-script-snowflake
    Prowadzi pisanie zapytań do Snowflake i musi być używany za każdym razem, gdy powstaje takie zapytanie.
  • 100notebook-audit
    Ocenia i poprawia notatnik Jupyter, skrypt lub model ML pod kątem wycieków danych, statystyki, powtarzalności i gotowości produkcyjnej.
  • 100pollen-view-structure
    Strukturyzuje widoki BigQuery we wzorzec widoków Pollen: pliki widoków i konwersja SQL z notebooków na budowniczych widoków, tylko w folderze research/notebooks/policy.

Uwagi i zgłoszenia

Wiadomość trafi do Bartosza Sokolińskiego. Adres e-mail jest potrzebny tylko do odpowiedzi. Szczegóły w polityce prywatności.