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]

Reply via email to