跳到正文
cccskills
免费在 GitHub 公开

exasol-export

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.

中文简介正在准备中。当前显示原文说明。

查看安装方法

包含的文件(2)

  • SKILL.md3.4 KB
  • references/export.md6.4 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Exasol Export Skill

This skill covers only workflows that move data out of Exasol.

Step 0: Establish Connection

Ensure a working exapump profile before giving terminal workflows that use exapump export:

  1. If the user names a profile, test it with exapump sql --profile <name> "SELECT 1"; always place --profile after the subcommand. Otherwise test the default profile with exapump sql "SELECT 1".
  2. On success, proceed — and keep the same --profile <name> after the subcommand on every later command, such as exapump export --profile <name> --table <schema.table> --output <file> --format <format>.
  3. On failure, run exapump profile list to see which profiles exist.
  4. If profiles exist, present them and ask which to use, then inspect that one with exapump profile show <name> — it masks credentials — to confirm the required fields are set. Never read, cat, or print ~/.exapump/config.toml; it stores credentials in clear text. If a credential value does appear in any command output, do not repeat it in the conversation.
  5. If no usable profile exists, have the user create one locally with exapump profile add <name> (omit --password and exapump prompts on a hidden line) or exapump profile init, then retry step 1. Never ask the user to paste a password into the conversation, and never pass one as a command-line argument.

Trigger when the user mentions EXPORT, EXPORT INTO, export table, export local file, exapump export, export CSV, export Parquet, export to S3, export to Azure Blob, export to GCS, export to FTP, export to SFTP, export to HTTP, export to HTTPS, REJECT LIMIT with export intent, or CREATE CONNECTION together with export target setup intent.

Routing Algorithm

  1. Local files on the user machine

    • Trigger phrases: export local file, into local, to local, exapump export
    • Load: references/export.md
  2. Remote or cloud files reachable by Exasol

    • Trigger phrases: EXPORT, EXPORT INTO, S3, Azure Blob, GCS, FTP, SFTP, HTTP, HTTPS, REJECT LIMIT, CREATE CONNECTION with export target setup intent
    • Load: references/export.md
  3. Connection-object export setup

    • Trigger phrases: CREATE CONNECTION with export target setup intent, ALTER CONNECTION, temporary credentials, SESSION TOKEN
    • Load: references/export.md
  4. Script-based export target

    • Trigger phrases: EXPORT INTO SCRIPT, export script, custom export script
    • Load: references/export.md

Notes

  • Use this skill for direct data movement out of Exasol.
  • Use exasol-import for native IMPORT, local upload workflows, Parquet import, reject handling, and staging-based loading into Exasol.
  • Use exasol-cloud-storage-extension for explicit extension-based Parquet export. Use exasol-extension-catalog only when the user is still choosing among native export, extension, connector, or integration families.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

exasol

免费

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.

中文简介正在准备中。当前显示原文说明。

exasol-labs/exasol-agent-skills102026年10月14日 更新

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.

中文简介正在准备中。当前显示原文说明。

exasol-labs/exasol-agent-skills102026年10月14日 更新

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.

中文简介正在准备中。当前显示原文说明。

exasol-labs/exasol-agent-skills102026年10月14日 更新

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.

中文简介正在准备中。当前显示原文说明。

exasol-labs/exasol-agent-skills102026年10月14日 更新

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).

中文简介正在准备中。当前显示原文说明。

exasol-labs/exasol-agent-skills102026年10月14日 更新

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.

中文简介正在准备中。当前显示原文说明。

exasol-labs/exasol-agent-skills102026年10月14日 更新

查看 exasol-labs 的全部技能

报告此技能的问题