Some questions about setting up and executing Achilles

That is expected, the OMOP vocabulary data from Athena only covers the vocabulary tables.

You will have to populate the other tables with the data from your own institution or with synthetic data.
See also this topic: There is a problem in running Achilles