SQL

Extending BigQuery Functions Beyond SQL With Remote Functions, Now In Preview
Today we are announcing the Preview of BigQuery Remote Functions. Remote Functions are user-defined functions (UDF) that let you extend BigQuery SQL with your own custom code, written and hosted in Cloud Functions, Google Cloud’s scalable pay-as-you-go functions as a service. A remote UDF accepts columns from BigQuery as input, performs actions on that input …

The Power Of A Modern Database: YugabyteDB And VMware Tanzu
As companies around the world and across industries engage in app modernization initiatives, their developers find it increasingly difficult to match those efforts with a strong data layer. Developers today continue to work with costly monolithic databases like Oracle or DB2 and NoSQL databases that forgo strong data consistency and important relational features. It’s clear that a …

Using The Local Timezone With Cloud SQL For SQL Server
If you want to use your local timezone for your database running on Cloud SQL for SQL Server, then this blog is for you. Cloud SQL is a fully managed relational database service for Microsoft SQL Server, MySQL and PostgreSQL. With Cloud SQL, you can run the same relational databases you know with their rich …

Learn How To Stream JSON Data Into BigQuery Using The New BigQuery Storage Write API
The Google BigQuery Write API offers high-performance batching and streaming in one unified API. The previous post in this series introduced the BigQuery Write API. In this post, we’ll show how to stream JSON data to BigQuery by using the Java client library. The Write API expects binary data in protocol buffer format. This makes …

Launching New Feature Or Games On Existing Cloud Spanner Database With Load Generator Tool
Game developers often reuse their existing database platform to launch their new games or launch new features to their existing games. This requires the database to scale in terms of new schema (tables, index, etc.), data and traffic. For games built with Cloud Spanner databases, most database operations can be done seamlessly, without affecting production …

To User-Friendly SQL With Love From BigQuery
Thirty five years ago, SQL-86, the first SQL standard, came into our world, published as an ANSI standard in 1986 and adopted by the International Standards Organization (ISO) in 1987. On this Valentine’s Day, we, in BigQuery, reaffirm our love and commitment to user-friendly SQL through a whole slew of new SQL features that we’re …

Yugabyte Cloud Offers Database Scale AND Transactional Consistency
Peanut Butter and Jelly. Infinity Gems and the Infinity Gauntlet. Server Virtualization and Shared Storage. Holidays and Cookies (ok, maybe that’s just a personal preference). We all love to find a combination of products, foods or technologies that effortlessly fit together to make our lives better. And when it comes to technology, there’s nothing better …

Scaling Read-Only Workloads On Cloud SQL For Postgresql With HAProxy
Cloud SQL is Google Cloud’s fully managed relational database service for MySQL, PostgreSQL and SQL Server workloads. Cloud SQL enables customers to implement horizontal scaling of read-only workloads using read replicas. In this blog post, we will demonstrate a single-endpoint read scaling and load balancing solution using Cloud SQL for PostgreSQL and HAProxy, with automatic …

Explaining Machine Learning Models To Business Users Using BigQueryML And Looker
Organizations increasingly turn to AI to transform work processes, but this rapid adoption of models has amplified the need for explainable AI. Explaining AI helps us understand how and why models make predictions. For example, a financial institution might wish to use an AI model to automatically flag credit card transactions for fraudulent activity. While …

Keep Tabs On Your Tables: Cloud SQL For MySQL Launches Database Auditing
If you manage sensitive data in your MySQL database, you might be obligated to record and monitor user database activity, especially if you work in a regulated industry. Although you could set up MySQL’s slow query log or general log to create an audit trail of user activity, these logs significantly impact database performance and …