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

December 18, 2018

SQL Query Releases Serverless Transformation and Partitioning of Data in Open Formats

We're excited to announce that SQL Query now allows you to specify the format and layout in which a result for a SQL query is written. By adding these abilities we're opening up serverless data transforming in IBM Cloud Object Storage.

Continue reading

October 12, 2018

Cloud Functions Package Design and Best Practices

Whether they're JARs, libs, Gems, or modules, successful programming languages provide an ability to share and re-use code. IBM Cloud Functions is no different—it enables developer productivity through installable packages. But what makes a good package?

Continue reading

September 10, 2018

Analyzing Data with IBM Cloud SQL Query

In this article, we're going to give you an introduction to getting set up with IBM Cloud SQL Query and using its UI. Then, we'll compose and run queries in a Jupyter Notebook on Watson Studio with the SQL Query Python library and PixieDust.

Continue reading

September 6, 2018

Geospatial Without Projections in IBM Cloud SQL Query

This is the first in a series of articles explaining the key highlights of the geospatial functions of IBM Cloud SQL Query. We will cover the Full Earth feature of the geospatial functions in this article—i.e., every topological and metric function operating on the Full Earth or the ellipsoidal Earth model.

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 8, 2018

Creating A Microservice Data Lake With IBM Cloud Object Storage and IBM SQL Query

Is your application's data a stream trickling into a puddle or a rising tide overwhelming the levees? Either way, IBM has you covered with tools to store, retrieve, query, and gain insights from data of any size.

Continue reading

July 9, 2018

Building Highly Available Apps with IBM Container Service, Kubernetes, and Rancher 2.0

This is the first in a three-part series on “Building microservice data lakes with IBM Cloud.” In this series we’ll explore how you can use IBM Cloud to deploy microservice applications, store data generated by those microservices in IBM Cloud Object Storage, and then query across that data using IBM Cloud SQL Query. Building an […]

Continue reading

June 12, 2018

Serverless log file analysis with web scale using IBM SQL Query

The applications we build and the systems we run generate a massive amount of logging data ranging from alerting, monitoring, availability and performance. Analyzing logs, or log analytics, is a widespread practice to capture insights from mobile data, IoT devices, servers, websites and other sources. Most companies need programmatic access to this massive amount of […]

Continue reading