How to add a column in smart query?
Hi @vignesh.sivakumar,
To add a single column or multiple columns to existing smart query follow these steps.
Step 1: Access the configuration sidebar and select Train Athena under the Data Workbench menu to open the Subject Matter Expert (SME) Coaching page.
Step 2: Go to the Columns tab, select the Smart Query to which you want to add columns and click on it.
Step 3: Enter the required password to access the Smart Query, then click Proceed.
NOTE
The Smart Query table is secured with a passcode accessible only to the data administrator. While users can view the column names and data types, only the data administrator can make modifications, as the Smart Query is protected.
Step 4: Modify the query in the query space provided.
Step 5: Click on Format Query to standardize the query’s format, then select Validate Query to check its accuracy and ensure it is error-free. The Validate Query function will also execute the query and display the results below.
Step 6: Once validated and the result is displayed click on the Update button to update the existing smart query with the newly modified one.
Step 7: The page will now redirect to SME coaching and your Smart Query is now ready to use. Click Publish to publish your Smart Query.
1 Like