-
Title
How to run a query to append (Union) data from multiple database platforms? -
Description
What is the process to run a query to append (Union) data from multiple databases or csv files?
-
Resolution
For general cross platform Unions:
1. Make connections to the databases that you want to use
2. Click the dropdown bar associated with the 'Build' button and select 'Cross-Connection Query Builder'
3. The Object Explorer should show you a tree view of the tables available. Drag a table from the Object Explorer from one database
4. Check the columns to display
5. Click the 'Union (U)' button
6. Drag table from Object Explorer from the other database (ensure that the datatype and number of columns selected match your original
selection, otherwise an error will occur on execution)7. Click the Execute SQL button
For appending multiple csv files:
Use the steps above if the files are located in different folders. If they are in the same folder, then repeat steps above, but for Step 2, simply click the 'Build' button because a cross-platform query is not necessary.
-
Additional Information
Union (all database platforms)—Returns all rows found in any queried table, but removes any duplicate rows. Union All (all database platforms)—Returns all rows found in any queried table, including any duplicate rows. Note: The Union operators available vary based on the database connection.