Data Analytics

SQL Query Service Announces General Availability

Share this post:

IBM Cloud SQL Query is generally available as of August 24, 2018

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 August 24, 2018.

IBM Cloud SQL Query is a fully managed service that lets developers analyze and transform data stored across multiple files in multiple formats using ANSI SQL statements. The service can query across CSV, Parquet, JSON, and ORC (with planned support for AVRO) files stored in IBM Cloud Object Storage without the need to move or transform data beforehand.

Along with stability enhancements, the generally available service features support for Geospatial SQL functions, allowing developers to efficiently index and query geospatial data. The combination of geospatial analytic functions with the serverless architecture of SQL Query makes it very easy to build location analytics solutions with your data in the Cloud.

Geospatial SQL functions that are now available include the following:

  • Geodetic functions that are accurate for all geometries without the need for projections, including large geometries like entire countries or hemispheres and geometries that are near the poles or the anti-meridian.
  • Geohashes on all geometries, enabling improved overall performance, spatial indexing and spatial joins, and computing spatial aggregates.

Get started for free

There are two plans currently available in the GA release:

Lite Plan (free)

  • Data volume: Limited. Lite Plan customers can submit queries that scan up to 30 GB per day.
  • Concurrency: Limited. Only one query at a time, and Lite Plan customers cannot submit a queue of queries.
  • Priority: Lower Priority. Queries submitted by Lite Plan customers will always be prioritized below/behind the queries submitted by Standard Plan customers.

Standard Plan

  • Data volume: No limits. Cost is $5 per Terabyte of data scanned in a month. There is no charge for failed queries, and canceled queries are charged based on the data scanned up until cancellation.
  • Concurrency: Up to 5 concurrent queries
  • Priority: Highest Priority. Queries prioritized above Lite plans.

Helpful hints and tips

To make the most of the IBM Cloud SQL Query, consider storing your data in an optimized columnar data format like Parquet. You can significantly shrink the physical size of data being stored due to compression. The columnar format and the compression overall leads to significant savings for I/O for scanning the data with SQL Query. This decreases your per-query cost and can accelerate your query performance.

For more helpful tips, check out our data-modeling guidance on big data layout in IBM Cloud Object Storage to explore other performance enhancements you can make to your data the client-side.

Upgrade your beta accounts

Beta instances of IBM Cloud SQL Query will sunset as a result of the GA. Here’s what you need to know:

End of Beta Date: August 24, 2018

As of August 24, 2018, new IBM Cloud SQL Query Beta instances cannot be provisioned. However, existing instances will continue to be supported.

End of Beta Support Date: October 4, 2018

For a period of 41 days after the End of Beta Date (through October 4, 2018), all existing instances will continue to be available on the Services dashboard in the IBM Cloud console. All existing instances will also continue to be supported by IBM Cloud SQL Query.

Any Beta instance still provisioned as of the End of Beta Support Date will be deleted.

Migration directions from Beta to Lite or Standard SQL Query plans

  1. Click into your SQL Query “Beta” plan from the IBM Cloud dashboard.
  2. Select “Plan” in the left navigation pane.
  3. Select “Lite” or “Standard” depending on which plan you would like to use. This can be changed at any time.
  4. Click “Save.” Changing your plan does not incur any downtime or require restaging your application.

Visit IBM Cloud to sign up for a free SQL Query Lite Plan to get started right away. If you need assistance, you can reach out to our support team directly.

 

IBM Watson and Cloud Platform

More Data Analytics stories
April 23, 2019

Announcing the Deprecation of the Watson Machine Learning JSON Token Authentication Service

We’d like to inform you about the deprecation of the Watson Machine Learning JSON Token Authentication service. This method of authentication will be retired on May 30, 2019.

Continue reading

April 9, 2019

Deprecating IBM Cloud Activity Tracker

We are announcing the deprecation of the IBM Cloud Activity Tracker service on April 30, 2019.

Continue reading

April 5, 2019

IBM Cloud App ID: Updated Runtime APIs Provide Tighter Interoperability for Your Cloud-Native Apps

As part of our efforts to tighten interoperability and broaden the frameworks that are able to use IBM Cloud App ID, we've updated the runtime APIs.

Continue reading