Parse JSON into SQL Server using Python
- or -
Post a project like this2010
£110(approx. $139)
- Posted:
- Proposals: 16
- Remote
- #2120999
- PRE-FUNDED
- Awarded
18 years expert in PHP, MySQL, HTML, CSS, JavaScript, jQuery, Ajax, Bootstrap, Chrome Extension, VB, VBA, AutIT Programming & Website Data Scraping
Ambala
Full Stack Software Developer | .Net | Angular | Cloud | AWS| Enterprise Application Development Partner | CRM |SharePoint | ERP
Mumbai
12407742324765241216366519701171043363130974815392951612431190209419714081971855
Description
Experience Level: Intermediate
I have a SQL Server instance.
I need a fairly simple Python script which extracts data from one table, including a column containing some JSON, and one containing the action type. The action type will determine the structure of the JSON (more details will be provided).
The script will need to loop through one table, parse out the JSON and insert / update / delete that data from other tables as required.
Importantly this will be parsing millions of rows per day, so the Python will need to be optimized for speed.
For an experienced Python programmer I don't think this should be more than a couple of hours work.
I need a fairly simple Python script which extracts data from one table, including a column containing some JSON, and one containing the action type. The action type will determine the structure of the JSON (more details will be provided).
The script will need to loop through one table, parse out the JSON and insert / update / delete that data from other tables as required.
Importantly this will be parsing millions of rows per day, so the Python will need to be optimized for speed.
For an experienced Python programmer I don't think this should be more than a couple of hours work.
Mike D.
98% (11)Projects Completed
17
Freelancers worked with
22
Projects awarded
69%
Last project
20 Jul 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Do you have sample format of python? Also is this to be run locally as script
700612
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies