A quick SELECT produced the story the business needed:
A mosaic, in art, is a picture created from many small tiles. The engineers borrowed the metaphor: each data source would be a tile and SSIS would be the grout that aligns, cleans, and assembles them into a single, coherent picture. ssis-440-mosaic-javhd.today03-02-16 Min
SELECT * FROM playback_logs WHERE date = '2016-03-02' AND hour BETWEEN 3 AND 4 A quick SELECT produced the story the business
During the first test run the tile produced duplicate VIDEO_ID rows because the same session was split across two Parquet files. The engineers added a Sort + Remove Duplicates step and also introduced a checksum column ( MD5(VIDEO_ID + START_TS) ) to detect true duplicates. and assembles them into a single