Python scripting for data migration from one database to another database
$30-250 USD
Maksettu toimituksen yhteydessä
we are working on writing on python scripts to connect to the Snow-flake database and extract the required data from there and insert the data in the Postgres database.
As part of this work, I need to write logic in the python related to how we should insert or update data in the postgres tables
*********SBB Data load logic swap requirement********
We have 7 tables in total, 6 load tables and one lookup table
We need to make changes in the existing python script, regarding the logic how we load data in the tables (postgres) and also the status for 4 days.
Day1:
We insert the data and the status will be “Active”.
“Only insert”
Day2:
First, we insert the data with status as “Inactive” for the current day, then we update the status for Day1 as “Inactive” and finally for current day updated status will be “Active”.
“Insert, Update, Update”
Day3:
We update the day1 data status as “Active” and Day2 data status as “Inactive”.
“Update, Update”
Day4:
We update the day1 data status as “Inactive” and Day2 data status as “Active”.
“Update, Update”
Projektin tunnus: #18990461
Tietoa projektista
16 freelanceria on tarjonnut keskimäärin $173 tähän työhön
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Lisää
Hello How are you I have read your job description in detail . I am Xu It is a piece of cake Please contact me and Let's discuss more thanks for your posting . hope to hear from you .
Hi there, I am an experienced website developer, and I have 5 years experience in developing websites using HTML, CSS and PHP and several frameworks such as Wordpress, ASP.NET, Laravel, Codigniter, django and so on Lisää
We specialize and have 20 years of experience in Desktop/Web/Mobile application development. We provide our expert service in the following areas: • Artificial Intelligence • Automation Solutions • Data Science • Lisää
Hello, I'm an experienced developer and I'll be glad to help you with your project. You can see my portfolio and my pluralsight profile to check my proficiency in both python and sql. Feel free to contact me, I'll b Lisää
Hi, I have 7 years of professional experience in SQL design & development, Python development and automation. I can help you accomplish your task. Please feel free to discuss with me about the project. Thanks, Hari
I'm study on computer science. I can handle that easily with ORM it's safe and practical for you. I'm experienced for +2 years with Python. We can discuss all the detail on chat.
I am very good in Machine Learning, Neural Networks, Python, Software Architecture, who consistently delivers great work on time, every time? That's exactly what I'll do for you. I've never missed a deadline and usuall Lisää
Do you have a C and Python job and are looking for a talented and experienced C Programming and Python Developer? I believe that my experience and skill in this background will prove to be of great help to you. I have Lisää
I have extensive knowledge of using Python and PostgreSQL for both personal and professional projects. I can help you write a script to do what you need done and also help you schedule it if needed etc.