SQL Querying in OHDSI-in-a-box

[Vasyl_Atamanyuk]

Hello Team) I’m passing ehden training and having hard times to try on basic SQL queries.

1. Deployed and entered to remotew ohdsi-in-a-box VM
2. Opened SQL workbench
3. Run basic queries like SELECT* from VOCABULARY
4. Got an error http://prntscr.com/zbig75
   Maybe I’m doing smth not right) Please, help)

Thanks)

[rookie_crewkie]

Hello @Vasyl_Atamanyuk,

Try using fully-qualified table names in queries, with schema specified.

[Vasyl_Atamanyuk]

Thanks, @rookie_crewkie. I tried to overcome this issue and reproduced training from OHDSI 2019 symposium using Windows VM. The secret for me was to set search_path to ‘ohdsi’; I think, it would be good to include @mvanzandt 's tutorial into EHDEN ohdsi-in-a-box course

[rookie_crewkie]

The secret for me was to set search_path to ‘ohdsi’;

which basically changes the default schema for objects’ lookup (or alters the precedence), so the root cause is the same: wrong schema.

[Vasyl_Atamanyuk]

@Vasyl_Atamanyuk

Thanks, @rookie_crewkie. I tried to overcome this issue and reproduced training from OHDSI 2019 symposium using Windows VM. The secret for me was to set search_path to ‘ohdsi’; I think, it would be good to include @mvanzandt 's tutorial into EHDEN ohdsi-in-a-box course

@nigehughes, this request maybe relevant for Academy as well. Will use EHDEN forum further. Thanks)