CarlosJuncher03 opened a new issue, #9582: URL: https://github.com/apache/hop/issues/9582
### What would you like to happen? Implement automatic export and transfer of external SQL files referenced by transforms when executing pipelines remotely on a Hop Server. Currently, transforms such as **Table Input** and **Execute SQL Script** can reference external `.sql` files, but these files are not automatically included in the resource package sent to the Hop Server. The proposed enhancement should: - Automatically detect external SQL files referenced by transforms. - Include these files in the resource export ZIP sent to the Hop Server. - Update file references to point to the exported resources. - Ensure SQL files are accessible during remote pipeline execution. - Preserve existing behavior when resource export is disabled. - Reuse the existing `exportResources()` mechanism. **Initial Scope:** - Table Input - Execute SQL Script **Expected Result:** Pipelines referencing external SQL files should execute successfully on a remote Hop Server without requiring users to manually copy or synchronize SQL files between environments. ### Issue Priority Priority: 3 ### Issue Component Component: Hop Server -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
