Frequently asked questions

Get answers to common questions and links to learn more.

What is IBM Cloud® SQL Query?

IBM Cloud SQL Query is a stateless SQL service for analyzing rectangular data stored in IBM Cloud Object Store using ANSI SQL. SQL Query supports querying CSV, JSON and Parquet files.

How do I get started with IBM Cloud SQL Query?

To use IBM Cloud 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 IBM Cloud SQL Query instance.
  4. Open the IBM Cloud SQL Query UI.
  5. Your IBM Cloud Object Storage target will automatically appear.

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

Does IBM Cloud 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 IBM Cloud SQL Query costs.

1. IBM Cloud SQL Query scans data in your data volumes.

  • Your data is read-only for IBM Cloud SQL Query.
  • IBM Cloud SQL Query does not make inserts or deletes into the volume with the data being scanned.

 

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

  • Using IBM Cloud 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.

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 Cloud SQL Query work with IBM Watson® Knowledge Catalog?

Today, IBM Cloud SQL Query is not yet integrated with IBM 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 IBM Cloud SQL Query available?

IBM Cloud SQL Query is available globally.

How is access to IBM Cloud SQL Query controlled?

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

Is IBM Cloud 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 Cloud SQL Query priced?

IBM Cloud SQL Query is available in the IBM Cloud. 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?

No.

Will I be charged for cancelled queries?

You will only be charged for the data that had already been scanned at the point you canceled the query.

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

There are no additional charges for IBM Cloud SQL Query. You will have charges for the data stored in IBM Cloud Object Storage. Using IBM Cloud 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.

Next steps

To get started with IBM Cloud SQL Query, access the free trial.