To read data from an external table with restricted access to Personal Identifiable Information (PII) columns, you can use Amazon Athena Connector. You can read from Lake Formation, apply transformations, and write to a target.