Existing SQL
Add Another Database Table
Use Add from Database to introduce reviewed metadata for another table into an existing SQL query.
Steps
1
Open Review schema and update SQL
Start from the Imported SQL workspace.
2
Select Add from Database
Enter the exact table name and generate the focused extraction script.
3
Run the script yourself
Execute it in your database tool and paste or upload the metadata output.
4
Review columns and relationships
Keep the required fields and confirm how the table connects to the existing query.
5
Apply and verify
Review the updated SQL and Output Columns before database testing.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.