Skip to main content

Keboola

Keboola is my new favourite toy and I have lost many hours playing with it and so far all for free, they even have free training which I have mostly been able to follow with the free account, though the tool is clearly evolving quickly and the training is now over a year old. 

However finding Keboola and the free MySQL databases are what inspired me to start this project. 

What I like about Keboola (Free): 

  • So far (over a week) completely free and no credit card required. I am not anywhere near looking like I am going to use my allocation for this month. 
  • Easy to connect to Snowflake, Google Drive, Google Sheets, MySQL and much more. 
  • Free use of Snowflake, with Snowflake being so hot at the moment this is great. 
  • Lots of logging. 
  • Decent training that is mostly useful, 

The dashboard:


What I don't like: 

  • I couldn't get the gmail connector to work due to Google Security policies. 
  • Product is evolving so quickly that training is already date or can't be done on free tier? Including the tasks to get their certifications. 
  • Some things were not obvious but were, to be fair, answered by the training. 

Summary: 

I am sure I will do many more posts about Keboola but if you are an aspiring data person and want to widen your horizons or try out new tech then Keboola looks like a great option. Time will tell if I continue to find it interesting and easy to use, but so far I am impressed and love the ability so spin up a mini Snowflake database. 

Below is a screenshot of me using my snowflake database and I have linked to a very basic dashboard I built in a previous post. 



Labels:

Comments

Post a Comment

Popular posts from this blog

Keboola Flows

Really finding Keboola was the thing that kickstarted this project otherwise I would be trying to build custom code on a python cloud server and building everything from scratch.  In Keboola you build you data sources and destinations using connection details which is fairly simple and something I will likely cover in another post, same goes for transformations etc. Here though I am going to discuss Flows, this is where you bring everything together. On my free account there are some limitations.  My easiest flow is very basic:  Pull parkrun results e-mail from Gmail to Google Sheets (actually done by Zap not Keboola).  Keboola will, as often as I like, in this case once a week, pull the data from the sheet into its storage.  It will then transfer this to the target database. Currently I have this setup to be MySQL database but I can and might expand that to the Snowflake instance within Keboola.  I then, outside of Keboola, connect to the MySQL database f...
Post a Comment
Read more

Zoho Analytics

Have I finally found my BI Tool, one that lets me import data from Snowflake and share it for free? I know, no sooner have I posted about how hard it was to find a tool that could do anything from Snowflake than I come across Zoho. You can check out my dashboard on the following page . Below is a diagram that outlines the processes I have used to obtain this data. In summary my parkrun e-mail is pushed to Google Sheets every week by Zapier and Forms I submit every day are used to track the strength training I do. Keboola is then used to ingest this data into MySQL and or Snowflake where I then use views or the built in transformation processes in Keboola to shift the data into a format for reporting. Google Data Studio then connects to MySQL and Zoho to Snowflake to visualise the data. 
Post a Comment
Read more

Generative AI News - 03/03/2024

Here are some of the latest news highlights related to Generative AI from this week: Venus Williams and Brain.ai : Tennis legend Venus Williams has ventured into interior design with Brain.ai , a new generative AI-powered platform 1 . It’s fascinating to see how generative AI is being integrated into various domains beyond smartphones. Google’s Gemini AI Controversy : Google’s chatbot, Gemini , faced controversy due to its image generator mistakenly placing people of colour in Nazi-era uniforms. This incident highlights the importance of responsible AI development 2 . Apple’s Focus on GenAI : Apple CEO Tim Cook announced that the company will “break new ground” in generative AI this year 2 . Keep an eye out for exciting developments from Apple. Morph Studio for Filmmaking : Morph Studio introduces an AI filmmaking platform that allows weaving Stability AI-generated video clips into movies 2 . A creative application of generative AI! Adobe’s Project Music : Adobe unveiled Project Music...
Post a Comment
Read more