Anthony Njuguna - Data Engineer - Alert Scheduler with Telegram Integration

Alert Scheduler with Telegram Integration

An automated data engineering solution that schedules SQL queries as alerts, executes them on specified intervals, and sends results via Telegram

Project mission

The project's mission was to streamline workflows by automating the scheduling, execution, and reporting of SQL query results, enhancing data monitoring and enabling timely insights through seamless integration with Telegram.

Efforts

1. Implementing a scheduling mechanism

This effort is crucial as it forms the backbone of the alert system, ensuring that queries are executed at the right time to capture relevant data insights

2. Creating a data retrieval system for database interaction

This effort is essential for ensuring compatibility with various database systems and efficient retrieval of query results, enabling seamless integration with the alerting system

3. Implementing adaptable result formatting for user-friendly insights

This effort is critical for optimizing user experience and ensuring that data is presented in a clear and actionable format, catering to different data volume scenarios.

4. Integrating with Telegram Bot API

This effort is significant as it enhances the project's accessibility by providing a user-friendly interface for receiving alerts, promoting proactive decision-making based on timely data insights.

Results

Input

Example of alert schedule input file with corresponding alert queries to be excecuted

Output

Telegram robot displaying alert query results as a message at diffent times, in different format options (text, image, or file) depending on query result size

Tools and Technologies

Python, SQL, sqlite3, pandas

Telegram API

Questions?

Contact antonnm7@gmail.com to get more information about the project

Project History

Page updated

Google Sites

Report abuse