Posts by tag

SQL

4 posts
View Post

Sentiment Analysis With BigQuery ML

Introduction We recently announced BigQuery support for sparse features which help users to store and process the sparse features efficiently while working with them. That functionality enables users to represent sparse tensors and train machine learning models directly in the BigQuery environment. Being able to represent sparse tensors is a useful feature because sparse tensors are used extensively in encoding schemes like TF-IDF as part of data pre-processing in NLP applications and for pre-processing images with a lot of dark pixels in computer vision applications. There are numerous applications of sparse features such as text generation and sentiment analysis. In…
View Post
Share
View Post

A Tool To Help Fix SQL Code Using ChatGPT

Say hello to the newest addition to the world of artificial intelligence – ChatGPT! You may have heard of this innovative project before, but did you know that it can help you with your technical SQL questions? That’s right, with ChatGPT’s help, you can now make the most out of your SQL queries. Introducing SQLize.online – an online SQL playground that has integrated ChatGPT as its virtual assistant. Integrating the chatbot into the platform’s API was a relatively easy task, but fine-tuning the chatbot’s responses was a different story. It took considerable time and effort to make sure the chatbot’s answers were…
View Post
Share
View Post

Creating Your Own Programming Language

Among the thousands of programming languages in existence are hundreds of “domain-specific languages” (DSLs) that have been adapted from traditional languages so that non-programmers can do their work more efficiently. DSLs are used in a wide range of fields, from web development (HTML) and database management (SQL) to genetics and machine learning (TensorFlow). One challenge with DSLs is that they’re not always easy to create. In languages like C++ you usually have to hire an expert programmer to design the DSL by looking at programs you’ve written for your work to figure out common elements that should be incorporated, and…
View Post
Share
View Post

Work At Warp-Speed In The BigQuery UI

Data analysts can spend hours writing SQL each day to get the right insights. So it’s crucial that the tools in the Google Cloud Console make that job as easy and as fast as possible. Now, we’re excited to show you how BigQuery’s Cloud Console UI has been updated with radical usability improvements for more efficient work, making it easier to find the data you need and write the right SQL quickly. The new capabilities span the entire SQL workspace experience across three feature areas: New multi-tab navigation New resource panel New SQL editor   New multi-tab navigation One of…
View Post
Share