Below is the pileine design in databricks and it's not working out , kindly look on this and let me know whether it will work or not , I'm getting json files of different schemas from directory under the root directory and it read all the files using inferred schema since it has same level of columns at a high level and it has changes inside the body column , post that i have tried to filter the column body based on the sink and it was working and in one type of json file there will be an array inside the body and i tried to explode it and it doesn't work and on other type of json file , it will be of single string inside the body and i tried to select as a seperate column and that doesn't work as well , so i want to understand that if im doing the infer schema , the other things will not work inside the data or not.
