SQL JSON Data Extraction & Reorganization
Budget: $10 – $30 USD
- Read the JSON files from a table in the database.
- Extract specific keys or property values.
The challenge here is that the JSON schema will vary from file to file.
To be successful in this job, you should have:
- Proven experience in writing SQL for complex operations such as this.
- Strong understanding about JSON file structure and how to efficiently read and manipulate them.
- Ability to create MS SQL statement to read keys and values from JSON file
Attached is a sample of the two lines that need to be read in the result as columns (code and display)
- Extract specific keys or property values.
The challenge here is that the JSON schema will vary from file to file.
To be successful in this job, you should have:
- Proven experience in writing SQL for complex operations such as this.
- Strong understanding about JSON file structure and how to efficiently read and manipulate them.
- Ability to create MS SQL statement to read keys and values from JSON file
Attached is a sample of the two lines that need to be read in the result as columns (code and display)