I am looking for someone who can flatten a JSON blob via MySql queries using the ->> operator and/or JSON_TABLE function, COLUMNS function. Other functions and MySql functionality can be used, these are just examples.
Solution should only be a MySql query. (No java, .net, etc)
Source will be stored in a table and out put should be put into another table. Table and sample data attached.
Specific work is a query to:
1) Read from source table (src)
2) Flatten all JSON keys/value pairs
3) Write each key/value as a row in the destination table (dest) with the related itemID from the source table
json key = question
json value = answer
14 фрилансеров(-а) готовы выполнить эту работу в среднем за $138
I understand what you looking to Flaten JSON key/value blob via MySql query I can help you in this request now. Please send me messages whenever you available online.
Hi, I am an experienced Data Engineer with a solid background in SQL. I have already done Data processing with SQL. Let's have a call for more details about the project. Regards