IBM SQL Query

March 4, 2019

Data Skipping for IBM Cloud SQL Query

We're going to show you how data skipping can boost the performance of your queries with IBM Cloud SQL Query and reduce cost at the same time.

Continue reading

November 12, 2018

IBM Cloud SQL Query at Think 2019

IBM Cloud SQL Query is a serverless SQL service that enables cloud data-driven applications to come online faster with less specialized expertise and a lower cost. Check out the best sessions to attend at Think 2019 to learn more about SQL Query.

Continue reading

September 18, 2018

How To Convert CSV Objects to Parquet in Cloud Object Storage

If you're looking to lower storage costs by compressing your data and get better query performance when querying the data in Cloud Object Storage, you may want to click to learn how to convert CSV objects to Parquet.

Continue reading

September 4, 2018

Query and Analyze Call Logs with IBM Cloud SQL Query

IBM Cloud SQL Query lets you use standard SQL and Apache Spark SQL functions to query your structured and semi-structured data stored in Cloud Object Storage (COS). It’s a serverless solution that makes it easy to analyze lots of data in COS by pointing to the COS bucket that stores your data.

Continue reading

August 30, 2018

Querying Your Distributed Application Data Using IBM Cloud Object Storage and IBM SQL Query

In this third part of a four-part series on Operationalizing SQL Query, we'll bring together the microservices we deployed in Part 1 to query data in IBM Cloud Object Storage (COS) using the techniques we developed in Part 2 using IBM SQL Query with the goal of connecting our application's data to Business Intelligence (BI) tools.

Continue reading

August 28, 2018

SQL Query Service Announces General Availability

The IBM Cloud team would like to announce general availability (GA) of the IBM Cloud SQL Query. The Service was promoted from Beta to GA as of July 31, 2018.

Continue reading

August 2, 2018

Connecting to IBM Cloud Object Store in Kubernetes

Operationalizing IBM SQL Query: Part 2. In this article, we'll take a look at the best practices for connecting to IBM Cloud Object Storage from docker containers deployed in the IBM Cloud Kubernetes Service.

Continue reading

July 25, 2018

Querying Geospatial Data Using IBM SQL Query

Geospatial data plays a crucial role in data forecasting, spatial analytics, and reporting, especially in the fields of logistics and finance. With IBM Cloud SQL Query, you can now run SQL queries on geospatial data on files stored as CSV, Parquet, or JSON in IBM Cloud Object Storage (COS) using IBM's geospatial toolkit.

Continue reading

June 14, 2018

How to Layout Big Data in IBM Cloud Object Storage for Spark SQL

When you have vast quantities of rectangular data, the way you lay it out on object storage systems like IBM Cloud Object Storage (COS) makes a big difference to both cost and performance of SQL queries. However, this task is not as simple as it sounds. Here we survey some tricks of the trade.

Continue reading