Unable to join two csv files using %csv magic

[praveen-kanamarlapudi]

Describe the bug If I have two csv files and trying to join both, it's not working.

To Reproduce

1. Let's say we have a cust.csv file with cust_id, cust_name
2. Another CSV file named geo.csv file with cust_id, city, zipcode

Run a sql like below %csv select cust_name, city from cust.csv as a join geo.csv as b on a.cust_id = b.cust_id

Expected behavior The sql should join both the table and give cust_id and city info in a table.

Screenshots

Potential fix