We have currently finished our ETL process to the OMOP CDM. The only thing we are missing is filling the ERA tables (drug_era and condition_era). We are using the scripts privided by OHDSI (sqlScripts.knit) but they generate huge temporary tables (≈400GB), making the server to run out of memory and stopping automatically the query.
Is it normal? Did you experience a similar issue? How can we solve it?
Thanks in advance!