What is SQL Query?

IBM SQL Query is a stateless SQL service for analyzing rectangular data stored in IBM Cloud Object Store using ANSI SQL. SQL Query is currently in beta and supports querying CSV, JSON and Parquet files. There is no charge to use SQL Query during the beta.

How do I get started with SQL Query?

To use SQL Query, you’ll need an IBM Cloud Object Store account to store the results sets of your queries.

Follow these steps to get started:

1. Provision IBM Cloud Object Storage

2. Provision an IBM Cloud SQL Query instance

3. Click Manage on the Left pane of the provisioned SQL Query Instance.

4. Open the SQL Query UI.

5. Your Cloud Object Storage target will automatically appear.

You are now ready to submit queries against our sample data set or your own data.

Does SQL Query include IBM Cloud Object Storage, or do I need to bring my own IBM Cloud Object Storage?

You must bring your own IBM Cloud Object Storage accounts, and you are responsible for any and all costs you incur in your IBM Cloud Object Storage account, in addition to your SQL Query costs.

1. SQL Query scans data in your data volumes.

  • Your data is read-only for SQL Query.

  • SQL Query does not make inserts or deletes into the volume with the data being scanned.

2. SQL Query writes the results into new files in your specified IBM Cloud Object Storage bucket.

  • Using SQL Query will increase your IBM Cloud Object Storage usage and your monthly bill.

  • Customers are responsible for deleting volumes they no longer want to keep in IBM Cloud Object Storage.

How do I access IBM SQL Query?

IBM SQL Query is accessed through the IBM Cloud console or by using the SQL Query service REST API, ibmcloudsql, SQL cloud function, or the SQL Query Watson Studio notebook.

What powers IBM Cloud SQL Query?

IBM Cloud SQL Query is built on Apache Spark and uses Spark SQL to execute your queries. You can submit your queries via the UI or the REST API.

Does IBM SQL Query work with the IBM Watson Knowledge Catalog?

Today, IBM Cloud SQL Query is not yet integrated with the Watson Knowledge Catalog. However, this integration is high on our priority list so customers can publish queries, meta data, and data sets to the catalog as well as reference data assets registered in the catalog.

In which IBM Cloud regions is SQL Query available?

During the beta, SQL Query will be available only in the Dallas region of IBM Cloud. After the beta, SQL Query will be globally available.

How is access to IBM SQL Query controlled?

IBM Cloud SQL Query gives you control to access your data using IBM Identity and Access Management policies.

Is IBM SQL Query highly available?

IBM Cloud SQL Query is designed to be fault tolerant and highly available. It supports the IBM Cloud SLA .

How is IBM SQL Query priced?

IBM Cloud SQL Query is currently publicly available in the IBM Cloud as a beta service. During the beta, it is free to use SQL Query. At the end of the beta, you will be charged on a per-query basis, based on the amount of data scanned per month. There will be no charges for failed queries, but you will be billed for canceled queries based on the amount of data scanned.

Will I be charged for failed queries?

IBM SQL Query will not charge you for failed queries.

Will I be charged for cancelled queries?

If you cancel a query, you will be charged but only for the data that was scanned up to the point you canceled the query.

Will I be charged for anything else associated with IBM SQL Query?

There are no additional charges for SQL Query. You will have charges for the data stored in IBM Cloud Object Storage. Using SQL Query will increase your IBM Cloud Object Storage usage and your monthly bill. You are responsible for deleting volumes you no longer want to keep in IBM Cloud Object Storage.

Get started with IBM Cloud SQL Query

Get started with IBM Cloud SQL Query — serverless, interactive querying service to quickly and easily analyze data stored in IBM Cloud Object Storage.