OHDSI Home | Forums | Wiki | Github

Atlas (WebAPI) using BigQuery

Is it possible to use Atlas (or actually WebAPI) with BigQuery ??

(I think that the CDM can be in BigQuery and the R scripts also can comunicate with it, but WebAPI is on java, not sure if it is possible)

dear @Javier - yes, it is possible. ATLAS now supports BigQuery as one of the databases. Not sure I understand your comment about Java - could you please clarify?

Thanks gregk, never mind about the java question,

Ok, i checked better the documentation and found this

" Note: WebAPI’s database can only be installed using PostgreSQL, SQL Server or Oracle. The CDM database may exist on different database infrastructure (i.e. RedShift, SQL Server PDW, Google BigQuery, Impala, etc) " [source]

So WebAPI must work on PostgreSQL ?? or now can work also in BigQuery ??

Ah, i understand your question.

For ATLAS internal database - PostgreS, SQL Server or Oracle only. I would recommend sticking with PostgreS

Yeap, thanks a lot, all clear now
sorry for the confision

@Javier
I am new to this.I am having similar case, where CDM in BigQuery and want to have different database(Postgres) for Atlas. How do you call BigQuery CDM from Atlas? How did you configure?

t