Rishabh-Pandey
Databricks MVP

Try with this , this is for second point if first points already matches .

# Define key columns
key_columns = ["key_column1", "key_column2"]  # Adjust according to your data schema

# Perform an outer join to find mismatches
joined_df = landing_df.alias("landing").join(
    bronze_df.alias("bronze"),
    on=key_columns,
    how="outer"
)

 

Rishabh Pandey