gistfile1.txt

            SELECT
                image.Image_TableNumber,
                image.Metadata_ImageNumber,
                image.Metadata_Plate,
                image.Metadata_Well,
                image.Image_Metadata_Site,
                image.Image_Metadata_Row,
                cytoplasm.* EXCLUDE (Metadata_ImageNumber),
                cells.* EXCLUDE (Metadata_ImageNumber),
                nuclei.* EXCLUDE (Metadata_ImageNumber)
            FROM
                read_parquet('cytoplasm.parquet') AS cytoplasm
            LEFT JOIN read_parquet('cells.parquet') AS cells ON
                cells.Metadata_ImageNumber = cytoplasm.Metadata_ImageNumber
                AND cells.Metadata_ObjectNumber = cytoplasm.Cytoplasm_Parent_Cells
            LEFT JOIN read_parquet('nuclei.parquet') AS nuclei ON
                nuclei.Metadata_ImageNumber = cytoplasm.Metadata_ImageNumber
                AND nuclei.Metadata_ObjectNumber = cytoplasm.Cytoplasm_Parent_Nuclei
            LEFT JOIN read_parquet('image.parquet') AS image ON
                image.Metadata_ImageNumber = cytoplasm.Metadata_ImageNumber