GoogleBigQuery Automate

• Data Analysts: Need to retrieve and analyze satellite position data efficiently.
• Developers: Looking for a simple automation to integrate Google BigQuery with APIs.
• Business Analysts: Interested in tracking satellite data for reporting and insights.
• Researchers: Require up-to-date satellite position information for studies or projects.

This workflow automates the process of fetching satellite position data from an external API and storing it in Google BigQuery. It eliminates the need for manual data retrieval and entry, thereby saving time and reducing errors. By running on a schedule, it ensures that the data is always current, providing users with accurate and timely information.

1. Cron Node: Triggers the workflow every minute, ensuring timely data retrieval.
2. HTTP Request Node: Makes a call to the API endpoint https://api.wheretheiss.at/v1/satellites/25544/positions, fetching the latest satellite position data including latitude, longitude, and timestamp.
3. Set Node: Extracts the relevant data from the HTTP response and formats it for insertion into Google BigQuery. It organizes the data into key-value pairs, ready for upload.
4. Google BigQuery Node: Inserts the formatted data into the specified table within the dataset, ensuring that the satellite position data is stored for future analysis.