Atlas, WebAPI and BigQuery

[MatthewYoungLai]

Continuing the discussion from Grouping by complex expressions:

Grouping by complex expressions

Hi @matthewYoungLai. This looks very good.

One suggested next step for us would be to get the queries in WebAPI (specifically CDMResultsService) working–particularly since it backs the Atlas > Data Sources feature that replaces AchillesWeb moving forward. I would love to get your thoughts on this.

Have you looked into this yet and found any examples of queries that fail? I’m happy to help with continuing to add rewrites to get more queries working.

I was also planning to start looking into getting Atlas working on BigQuery. If you’re already working on this then I’d be interested in hearing details of your setup.

[t_abdul_basser (Taha Abdul-Basser)]

I am still modifying my test environment and have just begun to collect data, but will definitely let you know as I identify any problematic queries. Please keep going, as you are probably further ahead–particularly with your test environment. Perhaps we can do a Hangout to discuss collaboration, advice, etc?

[MatthewYoungLai]

Yes, let’s discuss. I sent an invitation for a hangout.

[CRoeder (Chris Roeder)]

Any luck?

[mgkahn (Michael Kahn)]

Yes. With work by Odysseus, Atlas and WebAPI works against GBQ backends. The Atlas version on the OHDSI public facing GitHub site contains the changes Odysseus needed to do to make it work.