| name | exasol-import |
| description | Use Exasol IMPORT SQL plus exapump local file upload workflows for moving data into Exasol. Covers CSV, FBV, Parquet, connection objects, cloud credential patterns, reject handling, and staging-based import workflows. |
Exasol Import Skill
This skill covers only workflows that move data into Exasol.
Step 0: Establish Connection
Ensure a working exapump profile before giving terminal workflows that use
exapump upload:
- If the user mentions a specific profile name, 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".
- If the check fails, run
exapump profile list.
- If profiles exist, ask which one to use and retry with
exapump sql --profile <name> "SELECT 1"; keep --profile after the subcommand.
- If a non-default profile is selected, include the same
--profile <name> after the subcommand on subsequent exapump commands, such as exapump upload --profile <name> <file> --table <schema.table>.
- If no profiles exist, tell the user to run
exapump profile add default and retry.
- Never read or reference the exapump configuration file.
Trigger when the user mentions IMPORT, IMPORT INTO, upload CSV, upload Parquet, local file load, exapump upload, S3 import, Azure Blob import, GCS import, Parquet import, or CREATE CONNECTION together with import or object-store loading intent.
Routing Algorithm
-
Local files on the user machine
- Trigger phrases:
upload csv, upload parquet, exapump upload, from local
- Load:
references/import.md
-
Remote or cloud files reachable by Exasol
- Trigger phrases:
IMPORT, IMPORT INTO, S3, Azure Blob, GCS, FTP, SFTP, HTTP, HTTPS, CREATE CONNECTION with import or object-store loading intent
- Load:
references/import.md
-
Parquet-specific behavior
- Trigger phrases:
parquet, SOURCE COLUMN NAMES, SkipCols, MaxConnections, MaxConcurrentReads
- Load:
references/import.md
Notes
- Use this skill only for direct data movement into Exasol.
- Use exasol-export for native
EXPORT, local export workflows, and CREATE CONNECTION questions tied to export target setup.
- Use exasol-database for general
CREATE CONNECTION questions, SQL, schema inspection, and table design.
- Use exasol-extension-catalog when the user is asking for extension-based object-storage loading workflows or federated-read alternatives rather than direct
IMPORT.