Raw SQL Data Source

The Raw SQL data source allows you to define a SQL query statement to retrieve data from a database you specify.

Example

SELECT customer_id, customer_name, COUNT(order_id) as total

FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id

GROUP BY customer_id, Customer_name

HAVING COUNT(order_id) > 5

ORDER BY COUNT(order_id) DESC