{% hint style="warning" %} The following document assumes that you understand the basics of connecting to databases on Appsmith. If not, please go over them before reading further. {% endhint %}
Redshift databases can be queried using the standard SQL syntax. All Redshift queries return an array of objects where each object is a row returned by the query and each property in the object is a column. Appsmith provides template queries to help with the syntax
Queries can take inputs from widgets using the mustache syntax inside the query {{ searchInput.text }} where searchInput is the name of the widget and text is the property of the widget.
{% hint style="warning" %} Don't forget to wrap your params with single quotes {% endhint %}
select * from users where username like '%{{Text1.text}}%'
Query data can be displayed in a table or chart using the mustache syntax {{ queryName.data }} . You can read more about displaying query data below
{% hint style="info" %} The widgets are automatically refreshed when the data is changed {% endhint %}
{% page-ref page="../building-the-ui/displaying-api-data.md" %}