Hi @Nilesh Patel ,
Thank you for posting query in Microsoft Q&A platform.
Could you please help me to understand, where the tables are? Also, any specific reason for using Spark SQL only here?
You can use PySpark also to create dataframe for you data. And then use
printSchema()function to see the schema of data frame. That way you can easily compare column names.
Hope this helps. Please let me know if any further queries.
Please consider hitting
Accept Answer and
Up-Vote button. Accepted answers help community as well.