It is always recommended to use tHiveClose connection so that you can free the connection settings immediately after your use.
You can add it as On SubJob Ok since you need to be sure that the previous activity has been completed. You can also add it tagged to tPostJob and in that case, the connection will get closed at the end of the job.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs