> ## Documentation Index
> Fetch the complete documentation index at: https://docs.streamnative.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Work with pfSQL on Cloud Console

<Note title="Note">
  This feature is currently in alpha. If you want to try it out or have any questions, [submit a ticket](https://support.streamnative.io/hc/en-us/requests/new) to the support team.
</Note>

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](/cloud/process/pulsar-functions/function-setup) 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.

   <img src="https://mintcdn.com/streamnative/DYzjgCK90kxVTpdd/media/pfsql-new-query.png?fit=max&auto=format&n=DYzjgCK90kxVTpdd&q=85&s=3009992b0a4c592d85bf76763ef1f6e4" alt="screenshot of create a query" width="1915" height="908" data-path="media/pfsql-new-query.png" />

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.

<img src="https://mintcdn.com/streamnative/DYzjgCK90kxVTpdd/media/pfsql-delete-query.png?fit=max&auto=format&n=DYzjgCK90kxVTpdd&q=85&s=65e55451d03e39af458b04645c4a2181" alt="screenshot of delete a query" width="1915" height="945" data-path="media/pfsql-delete-query.png" />

## Troubleshoot a query

1. On the left navigation pane, click pfSQL.

<img src="https://mintcdn.com/streamnative/DYzjgCK90kxVTpdd/media/pfsql-overview.png?fit=max&auto=format&n=DYzjgCK90kxVTpdd&q=85&s=8460d5441d54b30a5faee86770b454bb" alt="screenshot of pfsql overview" width="1913" height="800" data-path="media/pfsql-overview.png" />

2. On the pfSQL page, click the target query to enter its overview page.

<img src="https://mintcdn.com/streamnative/DYzjgCK90kxVTpdd/media/pfsql-query-details.png?fit=max&auto=format&n=DYzjgCK90kxVTpdd&q=85&s=b0478a424559dc598207f0ca7a365093" alt="screenshot of query details" width="1915" height="751" data-path="media/pfsql-query-details.png" />

3. Click the Logs tab to check out more details.

## What's next

* [Work with pfSQL CLI](/cloud/process/pfsql/pfsql-work-with-cli)
* [Get started with pfSQL](/cloud/process/pfsql/pfsql-get-started)
* [Understand pfSQL](/cloud/process/pfsql/pfsql-understand)
* [Built-in UDFs](/cloud/process/pfsql/pfsql-built-in-udfs)