Execute a Concert Data Apps query

Edit online

If your data source is connected, then you can execute a Concert Data Apps query. Executing a query retrieves specific data from a connected database and power your visual components.

Before you begin

You must set up the required data source. Refer to Setting up the Concert Data Apps data source.

Instructions

With your selected data source, refer to the following steps to execute a Concert Data Apps query:

Select your configured data source.
Enter your SQL statement in the query editor.
- For SQL, enter your SQL statement (example, SELECT * FROM orders).
- For REST, define the endpoint and method (example, GET, or products).
- For GraphQL, paste your GraphQL query.
Click Run Query.

This turns your query into a live data feed for building fully dynamic dashboards.

Use case: Execute an SQL query

With your selected Postgres data source, refer to the following steps to execute an SQL query:

Select your configured data source.
Toggle the Enable polling to auto-refresh the data.
If your data source gets configured, then you can query to fetch the data for your widgets.
Enter your SQL statement in the query editor.
Click Run Query.
View the results in a table preview.
You can use the Output data from the query:
- Mapped to widgets such as tables, charts, KPIs.
- Further refined by using Transformations (for example, filtering, formatting, or restructuring before visualizing).

Next step

You can use the query result to power your widget by mapping, refer to Display data in widgets.