Google's BigQuery ML Tool for Machine Learning Through SQL

Overview


Google BigQuery ML is the company’s cloud offering that will help data analysts (and data scientists) build models through SQL


BigQuery ML eliminates the need to move your data from the data warehouse, hence speeding up the model building process


Google has even released guides on how to get started with this, for both data analysts and data scientists


 


Introduction


Machine learning is THE buzzword of this decade. But job vacancies for experts in this field keeps increasing despite a gigantic amount of people wanting to get a piece of the pie. This is because machine learning is a complex field that combines knowledge, skill, innovation and domain expertise – and most aspiring data scientists are found wanting in at least one of these areas.


Source: Twitter


Most of these aspiring data scientists are coming from an IT background, with a good (or at least manageable) grasp of SQL. If you are one of these people, there’s good news – Google wants to help you get familiar with ML! The tech giant has released Google BigQuery ML, a cloud offering that enables developers to design and build models in BigQuery using standard SQL queries.


Check out the below GIF, posted on Google’s AI blog today, that gives a quick overview of how you can use the tool:




Below are some of the advantages this tool currently offers:


You don’t need to use Python to build models; SQL is the language BigQuery knows and uses to build and access models


Data engineers and data analysts who use SQL on a frequent basis can use this with their pre-existing BI tools and spreadsheets


Of course this helps speed up the model building process significantly as you no longer need to extract and export your data from a data warehouse!


Google has even documented a ‘getting started’ guide for both data analysts and data scientists who want to learn about this tool:



Data Scientists


 


Our take on this


Awesome news for SQL users! I personally know a lot of folks in IT who want to make the transition to machine learning, but are held back by the complexities this field has. BigQuery ML will clear at least a few of those hurdles for you. Learning and doing ML in a language you are absolutely familiar with is priceless.


Currently, BigQuery ML supports both linear regression and logistic regression models but they are working to integrate other techniques into the tool. We should expect to see that happen in the near future.


Comments

Post a Comment

Please Share Your Views

Popular posts from this blog

SSO — WSO2 API Manager and Keycloak Identity Manager

Image
In this article, we are going to see how to implement Single Sign-On (SSO) for WSO2 API Manager using Keycloak as a Federated Identity Provider. Also, we'll choose a deep-dive showing how debugging works with the WSO2 API Manager code to see what happens inside when it's configured with a third-party identity provider (i.e Keycloak in this example). High-Level Architecture This is what we are going to do in this tutorial. High-level architecture Software Needed Following softwares will be needed: WSO2 API Manager (2.6.0) Keycloak (6.0.1) Note : We aren’t getting to use WSO2 Identity Server as a middleman for this tutorial. The article is predicated on pure WSO2 API Manager 2.6.0 (all in one). Before We Start The tutorial will be divided into two parts. In the first part, I will explain how to install and configure Keycloak. In the second part, we will see how to install and configure the WSO2 API Manager. Before we start, let's modify the  /etc/hosts  file ...
Read more

Recommendation System Using Word2Vec with Python

Image
Overview Recommendation engines are ubiquitous nowadays and data scientists are expected to know how to build one Word2vec is an ultra-popular word embeddings used for performing a variety of  NLP  tasks We will use word2vec to build our own recommendation system. Curious how NLP and recommendation engines combine? Let’s find out!   Introduction Be honest – how many times have you used the ‘Recommended for you’ section on Amazon? Ever since I found out a few years back that machine learning powers this section – I have been hooked. I keep an eye on that section each time I log into Amazon. There’s a reason companies like Netflix, Google, Amazon, Flipkart, etc. spend millions perfecting their recommendation engine. It is a powerful acquisition channel and enhances the customer’s experience. Let me use a recent example to showcase their power. I went to a popular online marketplace looking for a recliner. There were hundreds of them. From Traditional two-position recliners ...
Read more

Video Analysis: Creating Highlights Using Python

Image
Overview Build your own highlights package in Python using a simple approach That’s right – learn how automatic highlight generation works without using machine learning or deep learning! We will implement our own approach to automatic highlight generation using a full-length cricket match   Your Subconscious Mind Receives Each And Every Thought That You Have and Absolutely Accepts It As The Truth, Feeding it back into your Daily Reality. Introduction I’m a huge cricket fan. I’ve been hooked to the game since I can remember and it still fuels my day-to-day routine. I’m sure a lot of you reading this will be nodding your head! But ever since I started working full-time, keeping up with all the matches has been a tough nut to crack. I can only catch fleeting finishes to matches rather than the whole package. Or I have to follow along with text commentary – either way, it leaves me wanting more. So the data scientist in me decided to do something about ...
Read more