To anyone new or somewhat new to querying the Sierra database, I recommend Jeremy’s slide deck as the presenter notes and slides provide a lot of insight regarding the location of key columns to use when forming joins. He doesn’t simply provide the final query, but walks through the reasoning behind many of the joins required with a trial-and-error approach.
Even if you’re not querying the acquisitions portion of the database, the lessons herein are valuable. The 360+ views in the sierra_view schema can be an overwhelming data model to sift through, even with the Sierra DNA documentation and ERDs.
*Not a paid spokesperson