메뉴
Use Exasol JDBC-based virtual schemas for federated read-only access to external databases. Covers database-source adapter selection, CREATE VIRTUAL SCHEMA, EXPLAIN VIRTUAL, metadata refresh, and query-side troubleshooting.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Exasol database interaction via exapump CLI and Exasol SQL. Covers SQL queries, schema inspection, table design, query profiling, analytics, and Exasol-specific SQL behavior outside exasol-import and exasol-export.
Catalog and routing guide for Exasol tools, extensions, connectors, integrations, and architecture patterns. Use when users ask how to extend, customize, deploy, load, explore, enrich, surface, scale, automate, govern, migrate, or integrate Exasol, including Exasol Labs tools, AI/ML, UDFs, lakehouse, SAP, Databricks, agentic workflows, or product/version status.
Top-level router for Exasol work. Use for any Exasol database, exapump, SQL, BucketFS, extension, integration, UDF, Script Language Container, or Exasol Personal setup task, then route to the narrowest specialized Exasol skill.
Build, install, validate, and debug custom Exasol virtual schema adapters. Covers source-specific JDBC dialect implementation with virtual-schema-common-jdbc, custom document-file adapter code boundaries, JAR packaging, BucketFS deployment, adapter script setup, EXPLAIN VIRTUAL validation, and adapter-side remote debugging workflows.
Use Exasol document-file virtual schemas for federated read-only access to object and file storage. Covers document-file adapter family selection, CREATE VIRTUAL SCHEMA usage, refresh workflows, and query-side troubleshooting.
Use Exasol Cloud Storage Extension workflows for moving structured object-storage files through extension UDFs. Covers setup prerequisites, fixed UDF entrypoints, supported import/export formats, connection-object credential patterns, and routing away from native IMPORT or EXPORT when the extension path is the right fit.
| name | exasol-jdbc-virtual-schemas |
| description | Use Exasol JDBC-based virtual schemas for federated read-only access to external databases. Covers database-source adapter selection, CREATE VIRTUAL SCHEMA, EXPLAIN VIRTUAL, metadata refresh, and query-side troubleshooting. |
Use this skill only for JDBC or database-source virtual schemas where Exasol queries external data in place.
Trigger when the user mentions JDBC virtual schema, database-source federation, query external database through a virtual schema, JDBC source adapter, supported JDBC dialect, or EXPLAIN VIRTUAL together with a JDBC/database-source virtual schema context.
Create or query a JDBC virtual schema
JDBC virtual schema, query external database, database-source virtual schema, JDBC source adapterreferences/jdbc-virtual-schemas.mdRefresh, explain, or troubleshoot a JDBC virtual schema
EXPLAIN VIRTUAL with JDBC context, ALTER VIRTUAL SCHEMA with JDBC context, REFRESH TABLES, partial refresh, connection validation, pushdownreferences/jdbc-virtual-schemas.mdChoose a JDBC adapter family
supported JDBC dialect, dedicated adapter, PostgreSQL virtual schema, Oracle virtual schema, SQL Server virtual schema, MySQL virtual schema, DB2 virtual schemareferences/jdbc-virtual-schemas.md