The article provides step-by-step instructions on how to create a your own views in Dashboard Authoring Console using customer SQL. It includes screenshots to guide users in navigating the process, from creating the dataset to using it in an analysis.

1. Navigate to dashboard authoring console.
2. Click on Datasets > New Dataset.
   
   
3. Scroll to the bottom. Click Redshift.
   
   Note: If you are not able to find the Redshift source, please raise a support ticket.
   
   
4. Click Create Dataset in the window that appears.
   
   
5. Click Use Custom SQL.
   
   
6. Click Edit/Preview data.
   
   
7. Search for the relevant customer name under Schema with the suffix _analytics.
   
   
8. It will load a list of views available from which you can write your own SQL query. The view name used in the query should follow the schema table name. The following example shows the correct syntax:
   
   
   select * from volkscience_analytics.volkscience_applications
   
   
   
9. Create the Query. Click on Apply to get a preview of the columns in the table. Give an appropriate name to the view and query. Then, click Save & Publish. Click Cancel to exit the query editor.
   
   
10. Now, the view created will be available for you to use in an Analysis in the Dataset list. Click on the dataset, then click Use in Analysis.
    
    
    
    
11. You can start creating your analysis.