Query execution using SAP HANA Tables – RightData

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Query execution using SAP HANA Tables

The query is a part of the QUERY STUDIO module. Using Query, users can execute single or multiple SQL Queries by selecting the desired data source profile. Let’s execute the Query using SAP HANA.

Let us walk through the below procedure:

Click the ‘QUERY STUDIO’ tab.

Hover on the left pane options to view the ‘Query Builder’ snippet.
Click the ‘Query’ option.

Note: The user can click the ‘Query’ from the left pane options. Also, he/she can directly click the ‘New Query’ button or ‘New Query’ text from the drop-down list.

Path 01: QUERY STUDIO > Query Builder > Query

Path 02: QUERY STUDIO > New Query

The user is navigated to the ‘Query Builder’ session page.

Let’s select ‘hana Livewire’ from the ‘Profile’ drop-down list.
Click the ‘Navigator’ from the right side of the page.

From the ‘Catalog’ tab, let’s pick ‘BIMC ALL_CUBES’ table from ‘_SYS_BI’ schema.
Click ‘BIMC ALL_CUBES’ table.

This action adds the ‘Custom Query’ SQL.
Click the ‘Execute Now’ button.

This action executes the SQL Query and the user is navigated to the ‘Results’ tab.