From the course: Complete Guide to Google BigQuery for Data and ML Engineers
Join today to access over 24,900 courses taught by industry experts.
Working with text in BigQuery - BigQuery Tutorial
From the course: Complete Guide to Google BigQuery for Data and ML Engineers
Working with text in BigQuery
- Now it's time to take a look at how we can work with text in BigQuery. We're going to talk about a function in the machine learning library that's called understand text. ML.UNDERSTAND_TEXT is BigQuery's function for working with natural language text and analyzing that text. And basically what it does, it allows us to integrate BigQuery with the Google Cloud natural language API. And this is really useful for us because basically from within BigQuery we can call functions which allow us to analyze text that we have stored in BigQuery tables. Now there are multiple inputs for understand text. Now we have to create what's known as a remote model. And a remote model is basically, you can think of it as a data structure within BigQuery, which contains information which allows BigQuery to know what model to run and also what service account to use, which is basically the identity that we will use to invoke the service. Now some other things that I just want to point out, these are some…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.