We are using Trino https://trino.io as our CDM database store as it has given us a big increase in performance over postgres.
I am working to get Atlas running on top of our CDM living in Trino. I have modified all the packages that I think need to be brought up to date for the running of the system, SQL Render, DatabaseConnector, Arachne and have had success running Achilles to characterize the CDM.
The system is able to send over queries to the trino system, the dashboards and codeset features both work. However, when trying to run a cohort characterization, we get hit with the error that batches are not supported:
java.sql.SQLFeatureNotSupportedException: Batches not supported
There seems to be logic for other CDM stores, Snowflake, Bigquery, Impala that also don’t support batches but I am a bit lost in where those are being implemented within the WebAPI or other packages code.
Any support or guidance on where to get this logic set would be greatly appreciated.
Thanks in advance.
Best,
Alex