Skip to content
cccskills
FreePublished on GitHub

exasol-document-virtual-schemas

Use Exasol document-file virtual schemas for federated read-only access to object and file storage — S3, Google Cloud Storage, Azure Blob Storage, and Azure Data Lake Storage Gen2 document files. Covers document-file adapter family selection, the EDML `MAPPING` definition, `CREATE VIRTUAL SCHEMA` usage, refresh workflows, and query-side troubleshooting.

The English summary is being prepared. Showing the original description.

See how to install

Files included (2)

  • SKILL.md2.8 KB
  • references/document-virtual-schemas.md5.9 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Exasol Document Virtual Schemas Skill

Trigger when the user mentions document virtual schema, document virtual schemas, document files virtual schema, document-file virtual schema adapter, EXPLAIN VIRTUAL for document-file/object-storage virtual schema troubleshooting, S3 document files, Google Cloud Storage document files, Azure Blob document files, Azure Data Lake Gen2 document files, or Azure Data Lake Storage Gen2 document files.

Routing Algorithm

  1. Create and query a virtual schema

    • Trigger phrases: document files virtual schema, S3 document files, Google Cloud Storage document files, Azure Blob document files, Azure Data Lake Gen2 document files, Azure Data Lake Storage Gen2 document files, query object storage
    • Load: references/document-virtual-schemas.md
  2. Refresh, debugging, and troubleshooting

    • Trigger phrases: document files virtual schema, S3 document files, Google Cloud Storage document files, Azure Blob document files, Azure Data Lake Gen2 document files, Azure Data Lake Storage Gen2 document files, REFRESH, partial refresh, connection validation, pushdown, EXPLAIN VIRTUAL for document-file/object-storage virtual schema troubleshooting
    • Load: references/document-virtual-schemas.md
  3. Choose the right document-file adapter family

    • Trigger phrases: document virtual schema, document virtual schemas, document-file virtual schema, document files virtual schema, S3 document files, Google Cloud Storage document files, Azure Blob document files, Azure Data Lake Gen2 document files, Azure Data Lake Storage Gen2 document files
    • Load: references/document-virtual-schemas.md

Notes

  • Use this skill for federated read-only access through virtual schemas.
  • Use exasol-import or exasol-cloud-storage-extension when the user wants to copy data into Exasol instead of querying it in place.
  • Use exasol-jdbc-virtual-schemas when the source is a JDBC database rather than object or file storage.
  • Use exasol-virtual-schema-adapter-development when maintained document-file adapters are insufficient and the user needs custom adapter code, packaging, or adapter-side debugging.
  • Use exasol-extension-catalog when the source or integration family is still undecided.
  • Use exasol-bucketfs if the task is specifically about uploading the adapter JAR into BucketFS.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

exasol

Free

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.

The English summary is being prepared. Showing the original description.

exasol-labs/exasol-agent-skills10Updated Oct 14, 2026

Exasol BucketFS file system management via the `exapump bucketfs` CLI. Covers listing, uploading, downloading, and deleting files and directories in BucketFS, the `bfsdefault` service and other bucket services, bucket structure, `bfs_*` profile settings, the `/buckets/<service>/<bucket>/<path>` UDF path, and staging JARs, models, and Script Language Containers for UDFs.

The English summary is being prepared. Showing the original description.

exasol-labs/exasol-agent-skills10Updated Oct 14, 2026

Use Exasol Cloud Storage Extension workflows for moving structured object-storage files through extension UDFs. Covers setup prerequisites, the fixed `CLOUD_STORAGE_EXTENSION.IMPORT_PATH` and `CLOUD_STORAGE_EXTENSION.EXPORT_PATH` entrypoints used with `FROM SCRIPT` and `INTO SCRIPT`, Parquet, Avro, ORC, and Delta files on S3, Google Cloud Storage, Azure Blob Storage, Azure Data Lake, HDFS, and Alluxio, connection-object credential patterns, and routing away from native IMPORT or EXPORT when the extension path is the right fit.

The English summary is being prepared. Showing the original description.

exasol-labs/exasol-agent-skills10Updated Oct 14, 2026

Exasol database interaction via the exapump CLI and Exasol SQL. Covers SQL queries and DML/DDL such as `SELECT`, `INSERT`, `UPDATE`, `DELETE`, `MERGE`, `CREATE TABLE`, `ALTER TABLE`, and `DROP TABLE`, `CREATE CONNECTION` connection objects without import or export intent, schema inspection, table design, `exapump sql` and `exapump profile`, query profiling, analytics, and Exasol-specific SQL behavior outside exasol-import and exasol-export.

The English summary is being prepared. Showing the original description.

exasol-labs/exasol-agent-skills10Updated Oct 14, 2026

Distributed machine learning, data mining, and iterative HPC with Exasol. Covers end-to-end ML pipelines (DISTRIBUTE BY + SET scripts + BucketFS), per-entity federated training with partial_fit and ctx.reset(), batch inference, map-reduce ensemble training, distributed ensemble and SON algorithm for frequent itemset mining (Apriori, FP-Growth, association rules, market-basket analysis), Lua execute script orchestration for iterative algorithms (k-means, SGD, gradient descent), scikit-learn model training, parallel hyperparameter search, per-entity forecasting, anomaly detection, model lifecycle in BucketFS (pickle/joblib/ONNX versioning), GPU acceleration via CUDA SLCs (PyTorch/TensorFlow/RAPIDS), and ML-specific performance tuning (skew, OOM, multi-pass chunking).

The English summary is being prepared. Showing the original description.

exasol-labs/exasol-agent-skills10Updated Oct 14, 2026

Use Exasol `EXPORT` and `EXPORT INTO` SQL plus `exapump export` local file workflows for moving data out of Exasol. Covers native CSV/FBV export, local CSV/Parquet exports with exapump, `CREATE CONNECTION` connection objects for export, FTP, SFTP, HTTP, HTTPS, and cloud targets on S3, Azure Blob Storage, and Google Cloud Storage (GCS), reject limits, and export credential patterns.

The English summary is being prepared. Showing the original description.

exasol-labs/exasol-agent-skills10Updated Oct 14, 2026

See all skills by exasol-labs

Report a problem with this skill