Step 4

Copy Data

Using the "SQL Set Rewrite Parser" engine, SQL Simulator takes the SQL and rewrites it so that SQL Simulator retrieves only the needed records from production and copies them to the database pod. However if you try to retrieve more data than allowed by the Data Access Control, the records set will not be copied to production

If there are any foreign key tables those tables will get populated automatically by the "SQL Set Rewrite Parser".

If you omit the where clause in your SQL then the entire table will be copied.