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 ‘Salesforce’ profile.
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 ‘Salesforce connection_AWS’ from the ‘Profile’ drop-down list.
- Click the ‘Navigator’ from the right side of the page.
- Let’s pick ‘Account’ table from the ‘Salesforce’ schema.
- Click the ‘Account’ 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.