joined = conn.sql(" select distinct v.country, CAST(a.value AS FLOAT) as value, g.value as gender, q.value as question, r.value as demo \ from women_wellness.violence v \ left join women_wellness.violence__value a on (a._dlt_parent_id = v._dlt_id) \ left join women_wellness.violence__gender g on (g._dlt_parent_id = v._dlt_id and g._dlt_list_idx = a._dlt_list_idx) \ left join women_wellness.violence__question q on (q._dlt_parent_id = v._dlt_id and q._dlt_list_idx = g._dlt_list_idx) \ left join women_wellness.violence__demographics_response r on (r._dlt_parent_id = v._dlt_id and r._dlt_list_idx = q._dlt_list_idx) \ ").df() joined