Skip to main content

Getting Weather Data

I decided that I wanted to ingest some weather data through a different means, this time combining Google API scripts to retrieve the data from the API and another script to connect to the MySQL Database and deposit the data. Both steps are setup on a schedule. 

Setting up the API Call: 

I followed the instructions from the following medium post to create a function in Google Apps Scripts that would call an API for me. I use it to call the weather API website and retrieve the weather data for where I live. 

These 2 things combined import the data into my Google Sheet as per: 


I have then set this up to run on a 4 hour schedule within Google Sheets using one of their triggers. 

Getting the data into MySQL:

So now that I have the data in Google Sheets I want to regularly import this data into a database as it only stores a single row in google sheet, though I could probably get it to persist here as well. Looking at my options with the JDBC drivers available MySQL could work and Snowflake couldn't easily and I didn't really want to use a Keboola Flow several times a day to track this. 

I found the following post and modified the code as needed for my weather data and MySQL credentials. I then set that to run on a schedule as well so the data would get imported into the MySQL database on a regular basis and I can look to integrate it with my parkrun and step data to look for correlations between times / number of steps and the weather. 

Weather API: 

MySQL Table Script:



Labels:

Comments

Post a Comment

Popular posts from this blog

Gen AI News - 01/04/2024

According to Gemini here is the latest news:  Here's a rundown on some recent Generative AI news you might find interesting: Nvidia's New Architecture: Nvidia announced their next-gen "Blackwell" architecture for GPUs [1]. This promises a significant leap in performance for running large language models and other generative AI tasks. AI for Mental Health: An article highlighted how chatbots powered by generative AI are being used to help Gen Z with mental health struggles [2]. Amazon Invests in Anthropic: Amazon is making a further investment in Anthropic, an AI startup focused on developing safe and beneficial AI [2]. This suggests big players are keen on the potential of generative AI. Google and Reddit Partner Up: There have been talks about Google and Reddit forming a new partnership [4]. This could involve using generative AI for content creation or recommendation on Reddit. Overall, the field of Generative AI is seeing continued investment and de...
Post a Comment
Read more

Gemini Gen AI News Today

Generative AI: This Week's Trends Shaping the Future The world of Generative AI (GenAI) is a whirlwind of innovation. This week has been no different, with exciting advancements and discussions shaping the future of this powerful technology. Here's a quick dive into the top trends that caught our eye: 1. The Rise of AI Memory: OpenAI made waves by introducing memory capabilities to a limited group of ChatGPT users. This allows the AI to remember details from past conversations, fostering more personalized and relevant interactions. This technology could revolutionize customer service chatbots and virtual assistants. 2. Generative AI for Healthcare Gets Specific: Research continues on how GenAI can benefit specific areas within healthcare. This week, a study emerged showcasing the potential for AI to streamline drug development by analyzing massive datasets of molecules and proteins. 3. The Power of Video and 3D Models: The creation of video and 3D models using generative ...
Post a Comment
Read more

Gen AI News - 12/03/2024

Google’s Beta AI Content Rewriting Tool : Google is testing an AI tool that finds and rewrites quality content. However, some critics argue that it may incentivize the production of AI-generated low-quality content 1 . The New York Times and OpenAI Controversy : A court filing alleges that The New York Times paid someone to hack OpenAI’s products using deceptive prompts. The situation raises questions about the ethical use of AI 1 . Optimizing GPTs for Online Visibility : Learn how to increase online visibility and click-through rates for your GPT models in the GPT Store and Google Search with six practical tips 1 . AI Democratizing SEO or Amplifying Incompetence? : Understand what AI can realistically do for SEO and manage expectations regarding results 1 . Google’s “Help Me Write” AI Assistant : Google has launched an AI writing assistant called “Help Me Write” for the Chrome browser. It suggests text based on website context 1 . Google’s Gemini: Laptop-Friendly Open Language Model :...
Post a Comment
Read more