Systems | Development | Analytics | API | Testing

Latest Posts

How do I move data from MySQL to BigQuery?

In a market where streaming analytics is growing in popularity, it’s critical to optimize data processing so you can reduce costs and ensure data quality and integrity. One approach is to focus on working only with data that has changed instead of all available data. This is where change data capture (CDC) comes in handy. CDC is a technique that enables this optimized approach.

Introducing BigQuery column-level security: new fine-grained access controls

We’re announcing a key capability to help organizations govern their data in Google Cloud. Our new BigQuery column-level security controls are an important step toward placing policies on data that differentiate between classes. This allows for compliance with regulations that mandate such distinction, such as GDPR or CCPA.

AI in depth: monitoring home appliances from power readings with ML

As the popularity of home automation and the cost of electricity grow around the world, energy conservation has become a higher priority for many consumers. With a number of smart meter devices available for your home, you can now measure and record overall household power draw, and then with the output of a machine learning model, accurately predict individual appliance behavior simply by analyzing meter data.

Query without a credit card: introducing BigQuery sandbox

Today we are announcing the BigQuery sandbox, a credit-card free path to enable new users and students to experiment with BigQuery at no cost—without having to enter credit card information. As organizations begin to collect more and more data, many find that a serverless data warehouse like BigQuery is the only platform that can scale to meet their needs.

Introducing six new cryptocurrencies in BigQuery Public Datasets-and how to analyze them

Since they emerged in 2009, cryptocurrencies have experienced their share of volatility—and are a continual source of fascination. In the past year, as part of the BigQuery Public Datasets program, Google Cloud released datasets consisting of the blockchain transaction history for Bitcoin and Ethereum, to help you better understand cryptocurrency. Today, we're releasing an additional six cryptocurrency blockchains.

How we built a derivatives exchange with BigQuery ML for Google Next '18

Financial institutions have a natural desire to predict the volume, volatility, value or other parameters of financial instruments or their derivatives, to manage positions and mitigate risk more effectively. They also have a rich set of business problems (and correspondingly large datasets) to which it’s practical to apply machine learning techniques.

Connecting BigQuery and Google Sheets to help with hefty data analysis

As enterprises amass terabytes of complex data, they need tools to house and make better sense of their information. This is why we’ve built BigQuery, to help data analysts deal with large datasets. But not all of us are data wizards. Many of us use spreadsheets to perform ad-hoc analysis.

New BigQuery UI features help you work faster

Since announcing our new interface back in July, our goal has been to make it easier for BigQuery users and their teams to uncover insights and share them with teammates and colleagues. Whether you’re a veteran or brand new to BigQuery, we wanted to highlight some of the major improvements we’ve made to the interface in the past five months. Some of this functionality was previously available in the classic UI, while other elements are totally new. Let’s take a closer look.

Taking a practical approach to BigQuery cost monitoring

Google BigQuery is a serverless enterprise data warehouse tool that’s designed for scalability. We built BigQuery to be highly scalable and let you focus on data analysis without having to take care of the underlying infrastructure. We know BigQuery users like its capability to query petabyte-scale datasets without the need to provision anything. You just upload the data and start playing with it.

How modern is your data warehouse? Take our new maturity assessment to find out

As more and more businesses turn to advanced data analytics to help them make smarter decisions, run real-time analytics, and improve business operations, an increasing number are modernizing their data warehouses to make it all possible. For many businesses, knowing how to modernize means understanding where their data warehouse sits on the spectrum between traditional and cutting edge. To help, we collaborated with TDWI to offer the data warehouse maturity assessment.