How to connect piezo accelerometer?

Yes, that looks right. R1 is needed to provide the ground current to the FET in the transducer.