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 freelancere byder i gennemsnit $161 på dette job
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, 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 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.