Queries
Build features over your data
Queries are essentially SQL queries that can be applied to your tables, allowing you to filter, aggregate, and manipulate data flexibly.
They become especially powerful with AI tables, as you can leverage structured outputs derived from unstructured data, enabling deeper insights with just a few commands.
Creating a Query
Navigate to “Queries” on the left menu column, and click on ”+”:
Enter a name for this query, then press “Create”.
Nodes
Here, you have a node where you can enter a single SQL SELECT
statement to query your tables directly.
These SQL statements can interact with your tables in the same way as standard SQL tables, with additional AI columns you can leverage for deeper insights.
For example, to get the top 2 features mentioned in successful calls:
We can run this by clicking on “Run”:
Click on “Save” to save this node, and “Publish” to publish it as an endpoint:
See more details on endpoints.