Hi @szymon_dybczak 

I already read the conversationtranscript.json file in databricks dataframe df

Below are the columns that I have in that dataframe

bot_conversationtranscriptid:string bot_conversationtranscriptidname:string content:string conversationstarttime:string conversationtranscriptid:string createdby:string createdbyname:string createdbyyominame:string createdon:string createdonbehalfby:string createdonbehalfbyname:string createdonbehalfbyyominame:string importsequencenumber:string metadata:string modifiedby:string modifiedbyname:string modifiedbyyominame:string modifiedon:string modifiedonbehalfby:string modifiedonbehalfbyname:string modifiedonbehalfbyyominame:string name:string

Only the content and metadata contains the json value

Can you please tell me the code to flatten the json columns that I have to do?