Query Solace PubSub+ Cloud using SQL with Steampipe

giri
giri Member, Administrator, Employee Posts: 103 admin
edited October 2023 in PubSub+ Event Portal #1

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

  1. 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"

Query Solace PubSub+ Cloud

Launch Steampipe CLI Tool

steampipe query

Start issuing queries on the tables.

Steampipe's seamless integration with Solace PubSub+ Cloud can allow us to harness the power of SQL to effortlessly interact with cloud resources, making querying PubSub+ Cloud a breeze. The combination of Steampipe's SQL-based querying and Solace PubSub+ Cloud's API can open new avenues for data-driven decisions with newfound efficiency.

So, let's embrace the magic of SQL and Solace PubSub+ Cloud and explore new avenues of opportunities. Let's make every query count!

Comments

  • Tamimi
    Tamimi Member, Administrator, Employee Posts: 489 admin

    Such a cool project 😍 Thanks Giri for all the details!