Need to append queries without re-pulling data from Teradata

Hey mtrando 

The functionality you're looking for is reference. References are copies of the original query that do not pull the query again. They allow you to copy the query and then make changes to it. Therefore, you can create a reference of each query and then append those to each other to save load time and avoid having to reload each query each time. 

Simply right click the query in query editor and select reference. This creates the reference table. You can do what you need to with those, create the appended query, and the ndisable load by right clicking each reference.