Discovery: find a curated set of PHI-relevant entities on a local

Source: 18-find-pii-local-filesystem.phisql

PhiSQL

-- Discovery: find a curated set of PHI-relevant entities on a local
-- filesystem mount used as an ingest staging area.
-- Compiles to the JSON in 18-find-pii-local-filesystem.json.

FIND PII IN 'file:///mnt/exports/intake/'
  WHERE entity_type IN ('PATIENT_ID', 'EMAIL_ADDRESS', 'PHONE_NUMBER');

Compiles to

{
  "operation": "FIND_PII",
  "source": {
    "uri": "file:///mnt/exports/intake/",
    "scheme": "file"
  },
  "where": {
    "type": "in",
    "column": "entity_type",
    "values": ["PATIENT_ID", "EMAIL_ADDRESS", "PHONE_NUMBER"]
  }
}