Question About Using Multiple Database Connections and DDL

[idontknow]

Hello,

I am reading through the documentation here and I have a couple questions

OHDSI/Achilles

1. Is this results schema supposed to be a blank schema and the tables will be written when the analysis is running or are the tables created during the run? It is not clear to me what we are supposed to see in terms of ‘results’
2. Can we have the results schema in another database? I ask because I want to test the R package process in a standalone database where I write schema privileges. As someone who is not very familiar with R, how would we rewrite the script to achieve this?

Thank you for your help!

[cli001 (Karen Li)]

1. Is this results schema supposed to be a blank schema and the tables will be written when the analysis is running or are the tables created during the run? It is not clear to me what we are supposed to see in terms of ‘results’

• As far as I understand, yes, results schema is supposed to be a blank one, and after you run Achilles analysis, tables will be created.

2. Can we have the results schema in another database?

• The results schema is always co-located in the same server as the cdm schema. Please see this post for details: Oracle/webapi schema not created

I am new to this too, and I hope someone who’s good at it would confirm it.

[Chris_Knoll]

Yes, there’s no harm in setting up a blank schema in the DB and having Achilles write to that new schema. Achilles will create the tables it needs to write to.

You can NOT have the schema in another database, because many of the queries involve reading from the CDM schema and then writing into the schema that Achilles uses.