Query Solace PubSub+ Cloud using SQL with Steampipe

giri · August 2023

Introducing Steampipe

Steampipe is an open-source tool that has redefined the way developers interact with cloud infrastructure. Breaking the barriers of traditional approaches, Steampipe empowers you to query Cloud REST APIs using the timeless language of SQL.

With Steampipe, you can now leverage the familiarity and efficiency of SQL to effortlessly explore and interact with cloud resources from various providers like AWS, Azure, Google Cloud Platform, and more. Steampipe streamlines your cloud data exploration by providing a centralized hub to query, visualize, and manage cloud resources.

Now, with Solace PubSub+ Cloud plugin for Steampipe, enhance your experience with the perfect blend of Solace PubSub+ Cloud and Steampipe's SQL magic!

Solace PubSub+ Cloud plugin for Steampipe

The Solace PubSub+ Cloud plugin is available in the Steampipe’s plugin registry

The Go-lang code serving the plugin are available on the GitHub.

Go-lang SDK for Solace PubSub+ Cloud REST APIs https://github.com/SolaceLabs/steampipe-solace-go-client-sdk

Source code of Solace PubSub+ Cloud plugin https://github.com/solacelabs/steampipe-plugin-solace

Feel free to check it out, and do share your feedback and suggestions for improvement here.

Getting Started

Install Steampipe CLI

Follow the instructions on the Steampipe CLI downloads page and install the tool corresponding to your OS.

2. Install Solace PubSub+ Cloud plugin

Run the following command in the terminal or command prompt.

steampipe plugin install solacelabs/solace

3. Get an API Token for PubSub+ Cloud REST APIs

Solace PubSub+ Cloud plugin requires an API Token. You can find more details on how to generate an API Token here – t Your PubSub+ Cloud REST API token.

4. Configure API Token & API URL on the plugin

The generated token should be set as value for api_token parameter in the plugin config file (~/.steampipe/config/solace.spc). If you are working with AU region, be sure to update the api_url parameter appropriately.

connection "solace" {

  # Get your API key from https://console.solace.cloud/api-tokens
  # This can also be set via the `SOLACE_API_TOKEN` environment variable.
  api_token = "XXXXXXXXX"

  # The API URL. By default it is pointed to "https://api.solace.cloud/"
  # If working with the AU region , use "https://api.solacecloud.com.au/"
  # This can also be set via the `SOLACE_API_URL` environment variable.
  api_url = "https://api.solace.cloud/"
}

plugin = "SolaceLabs/solace"