I have two inputs.
1. Google sheets/Local Excel - Manual
2. Processes data from SQL server - Auto
I need to check if there are any repetitions between the two inputs and send the unique records to the client side.
The client side part is quite open on how I will receive the data. All I need is the fastest way to reach the client side with my unique records.
Choice of Language: python.
I want suggestions on tools on aws or google that could help me achieve the same and the respective process as well.
Input 2, sql server is hosted in aws.
Bu iş için 6 freelancer ortalamada ₹2742 teklif veriyor
I see a simplistic way of creating key values in the source and destination. This matching can be done in SQL using query.
I will do this work within time. Relevant Skills and Experience Before this I haven't experience, but I assure you that will be best.
This is possible . Use Open-source Apache spark in local mode -Read the excel/csv and create adataframesay df1. -Read from Database in dataframe say df2 -join df1 and df2 to fetch unique records Relevant Skills and Daha Fazla
My Name Is Mr B.S.P.S. Kulathunga . I am 36 Years old. I birth on 1982 . 03. 08. I live in B.V. Stores, Hinguralakanda, Dehiowita in Sri lanka . I am married. I studied Eheliyagoda central collage in Eheliya Daha Fazla