FeatureBase Cloud has a built-in query editor that supports queries written using SQL and native Pilosa Query Language.
- Learn how to create a database
- Learn how to import data to FeatureBase
- Learn how to query FeatureBase data
- FeatureBase SQL-guide
- Click Query then use the following features:
|Choose a database containing your tables and data
|View and search the tables and views in your database
|Limit query results
|Limit query results to 10, 100, 1000 or 10000 rows
|Defaults to 100 rows
|Query editor supports one or more queries and auto-suggests valid SQL and PQL
|Select a query
|Select a specific line to run, or insert the cursor to run from that point down
|Run queries with Run button, or via your keyboard:
* Ctrl+Enter, or
* CMD + Enter
|Network error occurs if a query exceeds 4000 seconds before returning results.
|Results columns can be sorted ascending or descending, filtered, hidden, shown and exported to CSV
|View query history
|View and search all queries run during the current session.
|Query history is deleted when you logout or clear your browser cache