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. 



Comments

Popular posts from this blog

AI News

Here’s a concise roundup of the latest AI news from the past couple of days: AI Technology: Friend or Foe? Researchers and experts continue to debate the impact of artificial intelligence. Is it a boon or a threat? The discussion ranges from AI ethics to its potential in various fields. Read more here . 5 Ways Artificial Intelligence Will Change the World by 2050 Futurists predict that AI will revolutionize our lives in the coming decades. From healthcare to transportation, AI is set to transform industries. Explore the possibilities here . How AI Will Transform Businesses in 2023 Business leaders are embracing AI to enhance efficiency, decision-making, and customer experiences. Stay updated on the latest AI trends in the corporate world here . China’s High-Level AI Modules China is pushing the boundaries of AI with modular next-generation systems. These high-level AI technologies promise breakthroughs in fields like robotics, healthcare, and smart cities. Learn more here . The Future

MySQL - Free

 So I was looking at trying to get a cloud based database that was always on. I wanted to build some visuals over whatever data I ended up building and have the DB accessible from a cloud server seemed like the easy way. I wanted to keep it free because I hate spending when I don't need to, so that others could use it for free and because I was sure there must be options out there. In the end my life was made much easier by spending £10 but you can go with the same free option on this site. https://www.freemysqlhosting.net/ Although not super fast or super sized it gives you a free and easily accessible database. So far I have easily connected using phpAdmin, BeeKeeper Studio, Python, Google Data Studio and Keboola. I have had no issues at all unlike several other solutions I have tried including Heroku.  To setup the DB you just set your location and hit start, you will then be e-mailed the connection details and then use your favourite MySQL IDE and you are in.  Above is a snapsh

Free AWS Training

Whilst a lot of the information I am post on here is about how to actually build a free cloud data platform for yourself there is also some good training out there. Whilst you will need to pay to get access a lot of places want to entice you in with certain bits for free. In the data engineering space a popular option for training is places with hands on labs. With the rise of these cloud platforms training providers are able to spin up mini instances with lots of restrictions and allow you to do hands on training without fear of using something outside of the free tier.  As I said most of this training is not free, I did a trial month at Whizlabs and got myself a certification on Snowflake and AWS with hands on experience using their sandbox areas. Honestly despite finishing that course I don't feel like I learnt a huge amount, the labs were too regimented and the trainers were not overly engaging. If money were no object I would give A Cloud Guru a go but I am looking for free ma