Hi, I am just getting around to actually giving this query snapshot a go, but not sure if I am doing the right thing...

Create Data Set
-> Go to menu Views - Create - Query Snapshot
-> Accept Defaults and click 'Create Snapshot'
(At this point, the snapshot view is displayed, which is just a query of the created data set)
-> Go to menu Views - Edit Snapshot

This is the point where I can't do anything. There is a textarea which is where I would expect to update the query source (is that correct?). So the issue is, the text area is set the readonly. I tried a few different things but it doesn't update (editing the query directly through the html inspector, removing the readonly attribute,...) after clicking the update button.

(before I forget, there is also another minor formatting issue. If you click 'Show History' on the Edit Query Snapshot page, the web part that shows the history has the html tags being displayed. there is the attribute that looks like this: title="<br/><b>Dataset Snapshot History:</b>" - I presume the html tags aren't meant to be in there..)

I also tried updating the studies security to all can edit, basic security with editable data sets, and custom security with editable data sets and setting everyone to edit all - in case that had something to do with not being able to update the query, but no change. Unless, each time you load the snapshot view it is supposed to return the original query (even after changing the source) or should it reflect what you updated it too last?

..

I think I may have to do the pipeline over the above scenario anyway, as I don't think you can configure labs and visits to be sourced externally.

..

On the Oracle data source - I have enlisted in the source and created a couple of new classes in the BigIron module, basically a copy of the MySqlDialect and MySqlDialectManager and also registered it as per the other dialects. I presume I then just need to add a resource in labkey.xml and get the jdbc driver for Oracle database placed into tomcat/common/lib (as per the guide for sas external data source). I just have to test, and hopefully it'll be all good; no doubt i'll be back asking more questions on this if it doesn't work/i cant figure it out.