Page Comparison

...

1. In SQL Navigator (or similar tool), log in to analytics at GAP_PROD.
2. Ensure that the "Updateable" button is turned on. .
   1.   Image Added
3. Run the command: SELECT * FROM BSP_ANALYTICS_VALIDATION table.
4. Add a new row to the table.
   1. ID should be the next unused integer.
   2. INVOCATION: select * from analytics.<new view name> where rownum<10
      1. rownum<10 is a way to increase chances of hitting different data types during the invocation (instead of choosing just row 1)
   3. ENABLED: 1
      1. you can add a row and place a zero in ENABLED to avoid running the invocation, using the row as a temporary placeholder
   4. COMMENTS can be notes about placeholder, purpose of view, etc.
   5. KIND should generally be "query"
5. Once the new row is added, click the COMMIT button.

   !updateable.jpg!

   ...

   1. 1. Image Added