Athena Concept_Synonym Glue Ear

Developers
1

Hi All,

I’m in the process of loading the latest CONCEPT_SYNONYM table into our OMOP CDM and have come across an issue whereby there are 2 rows containing the same concept_synonym_name but one contains double quotes:
image

When loading into our Snowflake environment it fails due to the double quotes.
I would be grateful if someone could confirm whether this is a valid code.

Many thanks

2

Hi @Helen_Rooney_WWL

This synonym is valid and is represented in the source with double quotes. Also, it’s not the only row with double quotes in concept_synonym and concept tables. You should consider using the quote escape here.

Best,
Masha