oracle-samples/oracle-aidp-samples - 2ページ

aidp-jdbc-custom

Connect to ANY database that has a JDBC driver from an AIDP notebook using Spark's native `format("jdbc")`. Use when the user mentions a DB without a dedicated AIDP connector — SQLite, ClickHouse, DuckDB, generic JDBC URL — or wants to use a custom JDBC…

原文の言語: 英語

infa-migrator-overview

Router skill. Read this first whenever the user mentions migrating Informatica ETL (IDMC/IICS cloud mappings, PowerCenter 10.x repository XML) onto Oracle AI Data Platform (AIDP). Lays out the toolkit, the CLI command sequence, which infa-* skill handles each…

原文の言語: 英語

infa-analyze

Inventory, complexity, and compatibility report over an Informatica export — no cluster, no LLM call, no cost. Use before migrating anything, to know what's in an export, how complex it is, and which pieces this tool cannot convert. Accepts a directory or…

原文の言語: 英語

infa-deploy

Upload generated notebooks and create AIDP jobs via `infa2aidp cli deploy` (OCI-signed REST calls — upload files, create job objects). Use once notebooks from infa-migrate-mapping have been reviewed and are ready to land in an AIDP workspace. The upload and…

原文の言語: 英語

infa-lineage

Field-level data lineage report per mapping via `infa2aidp cli lineage`. Use when the user asks "where does this field come from" or wants a lineage artifact for documentation/audit purposes. Operates on the Informatica export directly (source mappings), not…

原文の言語: 英語

infa-migrate-mapping

Convert Informatica mappings (PowerCenter XML or IDMC/IICS JSON) into PySpark notebooks for AIDP via `infa2aidp cli migrate`. Covers --use-llm/--agentic, --comparison fidelity reports, --workers batch mode, and --target-catalog-type delta|adw. This is the…

原文の言語: 英語

infa-migrator-bootstrap

One-shot environment readiness check for the Informatica→AIDP migrator engine. Verifies Python + engine dependencies, which `infa2aidp` actually resolves, the LLM provider key (OPENAI_API_KEY on this Codex build), and (only if the user needs them) OCI/AIDP…

原文の言語: 英語

infa-optimize

Spark performance suggestions over already-generated notebooks via `infa2aidp cli optimize`, with an optional --auto-apply for the subset of suggestions safe to apply mechanically. Use after infa-migrate-mapping to check for Spark anti-patterns in the…

原文の言語: 英語

infa-rag

Manage the learned conversion-pattern store via `infa2aidp cli rag` (stats/list/export/import/clear). Use when the user asks what the tool has learned, wants to back up or move approved patterns between environments, or wants to reset the store. This is local…

原文の言語: 英語

infa-reconcile

Compare source-DB rows against a migrated AIDP target via `infa2aidp cli reconcile`, driven by a YAML config (row_count / schema / aggregate / data checks, with ignore_columns for audit/surrogate columns that never match). Use after a migrated notebook has…

原文の言語: 英語

infa-review

Human approval gate over LOW/MEDIUM/MANUAL-confidence conversions via `infa2aidp cli review generate|import`. Use after infa-migrate-mapping, before trusting any generated notebook, to surface every low-confidence conversion and REVIEW REQUIRED marker for a…

原文の言語: 英語

infa-analyze

Inventory, complexity, and compatibility report over an Informatica export — no cluster, no LLM call, no cost. Use before migrating anything, to know what's in an export, how complex it is, and which pieces this tool cannot convert. Accepts a directory or…

原文の言語: 英語

infa-deploy

Upload generated notebooks and create AIDP jobs via `infa2aidp cli deploy` (OCI-signed REST calls — upload files, create job objects). Use once notebooks from infa-migrate-mapping have been reviewed and are ready to land in an AIDP workspace. The upload and…

原文の言語: 英語

infa-lineage

Field-level data lineage report per mapping via `infa2aidp cli lineage`. Use when the user asks "where does this field come from" or wants a lineage artifact for documentation/audit purposes. Operates on the Informatica export directly (source mappings), not…

原文の言語: 英語

infa-migrate-mapping

Convert Informatica mappings (PowerCenter XML or IDMC/IICS JSON) into PySpark notebooks for AIDP via `infa2aidp cli migrate`. Covers --use-llm/--agentic, --comparison fidelity reports, --workers batch mode, and --target-catalog-type delta|adw. This is the…

原文の言語: 英語

infa-migrator-bootstrap

One-shot environment readiness check for the Informatica→AIDP migrator engine. Verifies Python + engine dependencies, which `infa2aidp` actually resolves, ANTHROPIC_API_KEY, and (only if the user needs them) OCI/AIDP reachability for deploy and reconcile. Use…

原文の言語: 英語

infa-optimize

Spark performance suggestions over already-generated notebooks via `infa2aidp cli optimize`, with an optional --auto-apply for the subset of suggestions safe to apply mechanically. Use after infa-migrate-mapping to check for Spark anti-patterns in the…

原文の言語: 英語

infa-reconcile

Compare source-DB rows against a migrated AIDP target via `infa2aidp cli reconcile`, driven by a YAML config (row_count / schema / aggregate / data checks, with ignore_columns for audit/surrogate columns that never match). Use after a migrated notebook has…

原文の言語: 英語

infa-review

Human approval gate over LOW/MEDIUM/MANUAL-confidence conversions via `infa2aidp cli review generate|import`. Use after infa-migrate-mapping, before trusting any generated notebook, to surface every low-confidence conversion and REVIEW REQUIRED marker for a…

原文の言語: 英語

snowflake-assess-estate

Read-only PREVIEW of a Snowflake environment from the operator's machine - inventory of tables and views with row counts, byte sizes and column types, plus the census of objects that are not tables or views, table-maintenance state and security posture. Use…

原文の言語: 英語

snowflake-clone-notebook

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…

原文の言語: 英語

snowflake-compute-proposal

Map Snowflake warehouses onto AIDP Spark compute clusters and produce a sizing and cost proposal. Inventories every warehouse with its size, multi-cluster scaling policy and auto-suspend, pulls observed credit consumption from ACCOUNT_USAGE where permitted,…

原文の言語: 英語

snowflake-medallion-clone

Create the medallion architecture on Oracle AI Data Platform - registering an EXTERNAL catalog of source type SNOWFLAKE by default, and generating Spark SQL for schemas, tables and views from an approved Snowflake plan only when the user has explicitly asked…

原文の言語: 英語

snowflake-migration-plan

Build a high-level Snowflake to AIDP migration plan and present it for approval. States which objects can migrate and which cannot with a brief reason for each, applies user-supplied restrictions such as excluded databases or size caps, derives dependency…

原文の言語: 英語

snowflake-migrator-bootstrap

First-run setup for the Snowflake to AIDP migrator. Finds or creates the one migration config file (snowmig-config.yaml), reads every field back with secrets masked, verifies Snowflake authentication by password, key-pair, programmatic access token or SSO,…

原文の言語: 英語

snowflake-migrator-demo

Dev mode. Run the entire Snowflake-to-AIDP migration pipeline against a built-in emulated estate and an emulated AIDP — no credentials, no network, nothing real is touched. Use when the user wants to understand what the migrator does before pointing it at a…

原文の言語: 英語

snowflake-migrator-overview

Router, runbook and shared rules for migrating a Snowflake estate onto Oracle AI Data Platform (AIDP). Read this first whenever the user mentions migrating, moving, assessing, inventorying or cloning Snowflake databases, schemas, tables, views or warehouses…

原文の言語: 英語

snowflake-provision-environment

Provision the migration environment inside AIDP for the prod flow - the workspace (name auto-translated to the simplest safe charset), the migration-assets compute cluster, optional cluster libraries from requirements-aidp.txt, the backup-snowflake-migration/…

原文の言語: 英語

snowflake-smoke-test

Check connectivity and permissions on both ends before any migration work. Verifies Snowflake is reachable and readable (list databases, read INFORMATION_SCHEMA) and, when AIDP coordinates are supplied, that the target catalog is readable and optionally…

原文の言語: 英語

snowflake-assess-estate

Read-only PREVIEW of a Snowflake environment from the operator's machine - inventory of tables and views with row counts, byte sizes and column types, plus the census of objects that are not tables or views, table-maintenance state and security posture. Use…

原文の言語: 英語

snowflake-clone-notebook

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…

原文の言語: 英語

snowflake-compute-proposal

Map Snowflake warehouses onto AIDP Spark compute clusters and produce a sizing and cost proposal. Inventories every warehouse with its size, multi-cluster scaling policy and auto-suspend, pulls observed credit consumption from ACCOUNT_USAGE where permitted,…

原文の言語: 英語

snowflake-medallion-clone

Create the medallion architecture on Oracle AI Data Platform - registering an EXTERNAL catalog of source type SNOWFLAKE by default, and generating Spark SQL for schemas, tables and views from an approved Snowflake plan only when the user has explicitly asked…

原文の言語: 英語

snowflake-migration-plan

Build a high-level Snowflake to AIDP migration plan and present it for approval. States which objects can migrate and which cannot with a brief reason for each, applies user-supplied restrictions such as excluded databases or size caps, derives dependency…

原文の言語: 英語

snowflake-migrator-bootstrap

First-run setup for the Snowflake to AIDP migrator. Finds or creates the one migration config file (snowmig-config.yaml), reads every field back with secrets masked, verifies Snowflake authentication by password, key-pair, programmatic access token or SSO,…

原文の言語: 英語

snowflake-migrator-demo

Dev mode. Run the entire Snowflake-to-AIDP migration pipeline against a built-in emulated estate and an emulated AIDP — no credentials, no network, nothing real is touched. Use when the user wants to understand what the migrator does before pointing it at a…

原文の言語: 英語

snowflake-migrator-overview

Router, runbook and shared rules for migrating a Snowflake estate onto Oracle AI Data Platform (AIDP). Read this first whenever the user mentions migrating, moving, assessing, inventorying or cloning Snowflake databases, schemas, tables, views or warehouses…

原文の言語: 英語

snowflake-provision-environment

Provision the migration environment inside AIDP for the prod flow - the workspace (name auto-translated to the simplest safe charset), the migration-assets compute cluster, optional cluster libraries from requirements-aidp.txt, the backup-snowflake-migration/…

原文の言語: 英語

snowflake-smoke-test

Check connectivity and permissions on both ends before any migration work. Verifies Snowflake is reachable and readable (list databases, read INFORMATION_SCHEMA) and, when AIDP coordinates are supplied, that the target catalog is readable and optionally…

原文の言語: 英語

snowflake-stage-board

Show the Snowflake-to-AIDP migration as a stage table before running it - which stages are supposed to run, which have run, and what each one found, with the writing stages marked. Use when the user asks what the plugin will do, what stage comes next, where a…

原文の言語: 英語