Week 56 - Stored Procedures & UDFs
Welcome to the Emoji Translator and Notification challenge! Your task is to develop a program that will tackle the usage of emojis. Our external partner supplies you with a file formatted as a CSV containing various emojis, and your mission is to translate these emojis into their corresponding typed format.
Even though they ensured us that these 3 emojis are the only ones to be used, we know from experience that that could change in a heartbeat.
Phase 1: Emoji Translation Your program should read the provided CSV file, extract the emojis, and convert each emoji to its respective typed format. For example, 🚀 should be translated to ":rocket:" and 😀 should become ":grinning:".
Phase 2: Emoji Notification We always want to stay ahead in the emoji game! Implement a notification system that will alert you whenever a new emoji appears in the CSV file. Your program should automatically detect any recently added emojis and send a message notifying you of the new discovery.
Frequency of Checks To keep the system up-to-date, your program should perform emoji checks once every week. This means you'll need to schedule a recurring system that examines the CSV file for any additions.
Guidelines:
- The program should be written in a language of your choice.
Get ready to embark on this emoji-filled adventure and have fun coding! Good luck! 🚀😀👍
Required Files:
The location for the new files is the s3://frostyfridaychallenges/challenge_56/ bucket.
This bucket contains 2 files: survey_resulsts.csv with the agreed upon emojis and 1, survey_results_2.csv with a 'new' emoji