Data transfer actions
Available since 25.3
AI data transfer actions help you run export, import, and comparison tools through natural language. When your request describes an action, Team Edition opens the appropriate wizard and picks the right mode or format based on what you asked.
To use the actions:
- Open AI chat on the connection you want to work with
-
Write a prompt that describes the export, import, or comparison you need
Note
To use an action, make sure it’s turned on in the Functions settings.
-
AI reads your request and opens the matching wizard with the right mode or format
Available actions¶
Use these actions when you want to export data to a file, import a file into a table, or move data between tables or databases. Just describe what you want in AI chat, and the assistant opens the wizard that matches your request.
| Action | What it does | What opens | Example |
|---|---|---|---|
| Compare data | Checks differences between tables or databases | - Data Compare wizard - Tables or schemas from your request pre-selected - Mapping adjustable before running the comparison |
"compare stage.Album data with prod.Album" |
| Compare schemas | Compares database structures | - Schema Compare wizard - Source and target databases filled in - You can review changes, scripts, and sync options |
"compare stage.Invoice schema with prod.Invoice schema" |
| Export query results to a file | Saves the current query results as a file | - Data export wizard in export mode - Format inferred from your request (CSV, XLSX, JSON, etc.) - Active results tab used as the source |
"export these results as a CSV file" |
| Export table data to a file | Exports one or more tables without writing SQL | - Data export wizard - Selected tables pre-filled |
"export stage.Album as CSV" |
| Import data | Imports a file into a selected table | - Data import wizard in import mode - Target table pre-selected - You pick the file - Column mapping shown after file selection |
"import a CSV file into my table" |
| Transfer data between tables | Copies data from one table to another | - Data migration wizard - Source and target tables set - Transfer method selected automatically - Filters and mappings adjustable before starting the job |
"migrate data from prod.customers to stage.customers" |
Note
To use an action, make sure it’s turned on in the Functions settings. If the matching action is enabled, the assistant opens the correct wizard automatically.