How do I execute my queries in the FeatureBase Cloud UI?

Table of contents

• Before you begin
• Step 1: Select database to query
• Step 2: Choose query limit
• Step 3: Write query in text editor
• Step 4: Execute the query
• Further information

You can also query data programmatically with the query endpoint

Before you begin

• Learn how to create a database
• Create a table
• Learn how to import data to FeatureBase
• Learn about SQL
• Learn about querying in Cloud
• Click Query to navigate to query editor

Step 1: Select database to query

There are two methods for defining the database you want to query in the UI:

Step 2: Choose query limit

Queries executed in the UI have an automatic limit of 100 records applied. This limit is applied to protect users from accidentally running taxing queries against their databases and impacting production performance, as well as browser limits. You can change the limit from a minimum of 10 records to a maximum of 10,000 records:

• Click the dropdown in the top right labeled Limit and select your limit

Step 3: Write query in text editor

Write a query using either the standard SQL Language or our native PQL Language in the text editor. The text editor allows for multiple queries to exist in the same pane. Individual queries are separated by newlines with only whitespace.

Step 4: Execute the query

The UI will execute the query that your text cursor is touching. There are two methods for executing a query in the UI:

Further information

• Use the schema browser
• Use the query history
• Query API reference
• fbsql CLI Reference

---