Posts in tag

SQL

Data

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 …

Read More
Cloud-NativeMulti-Cloud

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 …

Read More
DataEngineering

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 …

Read More
Engineering

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 …

Read More
DesignEngineering

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 …

Read More
code
Software Engineering

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 …

Read More
DataEngineeringPlatformsTechTools

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 …

Read More
Engineering

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 …

Read More
DataEngineering

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 …

Read More
DataEngineeringTools

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 …

Read More