Asked basic question on current architecture,problem faced and solution ci cd sdp clustering partition broadcast join self join left join outer join adf snowflake dbt spark sql Postgres five Tran machine learning tables power bi