Doing some testing. I have two tables from the same source - they should be mutually exclusive result sets, but may not be.
I created a third table using two SQLi -based tables to query the first two and set the key columns to eliminate any duplicate rows.
* All three are currently in the same schema and I've modified the load order so the two "source" tables are in group 1 and the composite table is in group 2*
Can I reliably expect that the two source tables will run to completion first and the composite table will then query those results? IOW - when do Incorta tables ( parquet files ) get locked/sequestered for load querying?
Solved! Go to Solution.