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.
We insert the data and the status will be “Active”.
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”
We update the day1 data status as “Active” and Day2 data status as “Inactive”.
We update the day1 data status as “Inactive” and Day2 data status as “Active”.
20 freelance font une offre moyenne de $161 pour ce travail
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. Plus
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, Dear! I`m great interested in your suggest. If you're interested - contact me. Let's get in touch to discuss your project in more detail via here. It would be great to discuss details to Plus
Hello? How are you? I have seen the project - "Python scripting for data migration from one database to another database." I have been working in these fields((Python, SQL)) for 7 yrs as a freelancer. I can work f Plus
Hello, dear! I am interested in your project. I have extensive experience in Python/MySQL. As a developer with rich experience, I am confident about your project. I will provide perfect results in a short time. If Plus
Hi there, I've gone through the post description carefully and ready to start work on this project. Requirements are very clear but please come over the chat so that i can get more requirements if remaining. I am Plus
Dear Client!!. I'm an expert of programming Thank you for your attention I am a Programmer with 7 years of experience in full circle of software development. I am interesting in Python and Statistics,Web Scrap Plus
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 Plus
Hi, Sir!!, Please give me your site url that you want to crawl. @$@$@$PLEASE CONTACT ME. I CAN DO IT IN 1 DAY $@$@$@ ##% Your idea is attracted me to your world. %## i use python selenium and beautiful soup for s Plus
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 • Plus
Hello. I can do your project using python sqlite3 library. This library is suit for RD management. Thanks.
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.
Hi, Hope my message finds you well. I have more than four years experience working as full stack python developer.I have hands on experience with python and postgres database.I had used postgres database with [login to view URL] Plus
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 Plus
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 Plus
Hello, how are you? I've read your description and I think I can give you the perfect result. I am a full stack developer and I have rich experience in Python and database. Please contact me. I will do my best Plus
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.
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 Plus
Hello I have huge experience in work with tabels and downloading data from them. I creat many programs that searched the text or data from tables and database, for example in last week pulled out telephone numbers Plus