App builder docs
Baseten application builder
Publishing your application
Application builder tutorial
Account and workspace
Members and roles
Write and save queries to access data from your applications.
Use Baseten's query builder to interface with data in your Baseten Postgres tables.
The query interface runs PostgreSQL directly on your data, so you have access to the
All queries through a query interface must return a value or they will fail. So, if adding or removing data, use
at the end of your query.
Queries to Baseten tables have a 15-second limit after which they will time out.
To write and save complex SQL, use the query builder, located in the "Queries" tab on the Data page.
Queries created with the Query Builder are accessible in Views to populate user-facing tables.
Give your query a meaningful name that will help you identify it in other parts of the baseten application.
Queries written in the query builder can reference multiple tables, and you can change the data source to write queries to external data sources.
If you want to rename a Query, click the three dots next to its name and enter a new name. You'll need to update its name anywhere it is referenced as well.
If you no longer need a query, you can delete it through the same menu. Confirm the deletion in the modal and it will be deleted.
to add parameters to your query. Parameters are useful when calling a query from a view. For example:
When testing the query, use the parameter menu in the query builder to add parameters.
Test query with parameters
If you want to run a one-off query on a single Baseten Postgres table, click the "query" button on the table list in the UI.
Query launch button
This launches a SQL shell where you can write any query.
This is a complete SQL interface, so you can alter the data and table. Double-check your queries before running them.
Queries written in this interface are not saved. Every time you launch the interface, it will load a default
DATA - Previous
Next - DATA