This feature is currently in alpha. If you want to try it out or have any questions, submit a ticket to the support team.
This section describes how to work with pfSQL on StremNative Cloud’s Cloud Console. You can create and delete a query.

​
Prerequisites

To fully use the feature provided by pfSQL, you will need to follow Set up your environment to set up your Pulsar Functions environment first.

​
Create a query

  1. On the left navigation pane, click pfSQL.
  2. On the pfSQL page, click New.
    1. Enter a query name with a description.
    2. Select a service account from the drop-down list.
    3. In the Query area, enter your query.
    screenshot of create a query
  3. Click Deploy.
By default, a newly created query is in running status. You can continue to pause/resume it based on your needs.

​
Delete a query

  1. On the left navigation pane, click pfSQL.
  2. On the pfSQL page, click the Ellipsis (…) icon in the row of the target query and select Delete.
  3. Type the query name to confirm and click Confirm.
screenshot of delete a query

​
Troubleshoot a query

  1. On the left navigation pane, click pfSQL.
screenshot of pfsql overview
  1. On the pfSQL page, click the target query to enter its overview page.
screenshot of query details
  1. Click the Logs tab to check out more details.

​
What’s next