Create & edit Data Service

Create a Data Service

To create a Data Service, follow these steps:

1. In your ReOrc project, go to Data Service.

2. Click on the + icon and select Create data service.

3. Provide the name for your Data Service.

4. Click Create.

Define SQL query

1. Click Edit query to define/ edit SQL query of the Data Service.

2. In the query editor, define connection for your Data Service.

3. Input your SQL query.

For example:

SELECT
    o.id AS order_id,
    c.name AS customer_name,
    o.order_total
FROM
    database_name.table_name o
JOIN
    database_name.table_name c ON o.customer = c.id
WHERE
    o.order_status = 'completed';

1. Click Update > Save to confirm the changes.

2. View the query output in the Data Preview tab.

Organize Data Services

To create a new folder, click on the action button of an existing folder and select Add sub-folder:

To move a Data Service into the new folder, click on the action button of the Data Service and select Move to. Then select the target folder from the list.