What does <Long String> do in analysis 117 of Achilles?

[lychenus13 (lychenus)]

We are trying on the Achilles analysis and the train is stuck on query 117.

Achilles/117.sql at master · OHDSI/Achilles · GitHub

I wanted to run the query alone and see what is wrong with it.

Just interested, what does @scratchDatabaseSchema@schemaDelim@tempAchillesPrefix_117 means?

[lychenus13 (lychenus)]

btw

Analysis 117 run for 6 hours and it didn’t come back on multiple machines.

I find it odd because the table observation_period has been used in previous Achilles analysis and they all came back okay, despite some of them might take more time.