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

AWS training cloud academy free course

One of the things I like about this course are the instructors are really clear but also that it provides free labs that allow you to actually sign into AWS and perform some actions to actually create and do things without worrying that you are going to incur a cost.  Today I complete one of the hands on labs.  This was to create a lambda function, in this case it was a very basic python script that was searching a website for a keyword. I then placed this into a schedule and used cloudwatch to create a dashboard that monitored the running of this function. Overall it was a very simple use case but it was also a very simple process to setup.  I don't have much to add to this other than it is well worth signing up to cloud academy for the free training if nothing else, I am tempted, once i have done some more training, to give the paid for option a go to get the full sandboxes. 

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 ...

Data Cleansing View in Snowflake

For part of one of my free ETLs I am using Zapps to transfer e-mails from Google Sheets and then Keboola to transfer the sheets into my Snowflake database. I am familiar with string searches and cleansing in Oracle and using python but have not had the chance to do this in Snowflake. I wanted to give it a go as a proof of concept if nothing else. There were some difference in functions between Oracle and Snowflake, no INSTR and using POSITION instead and some difference in working with dates / timestamps but overall it was very similar.  The code below is what I ended up using:  I think want to use this to create some overview graphics to allow me to track the success or failure of my ETLs. Assuming the aspects of Retool remain free you can see how much ETL is going on this link .  In case things aren't working, here is a table of the output I am producing.