Skip to content

Discovery: discover any high-confidence PII in a Google Cloud Storage prefix

Source: 16-discover-entities-gcs.phisql

PhiSQL

-- Discovery: discover any high-confidence PII in a Google Cloud Storage prefix.
-- DISCOVER ENTITIES is a synonym for FIND PII when the verb-first reading
-- ("discover any entities here") fits better than the noun-first reading
-- ("find PII here"). Both compile to operations a discovery engine accepts.
-- Compiles to the JSON in 16-discover-entities-gcs.json.

DISCOVER ENTITIES IN 'gs://analytics-exports/2026/'
  WHERE confidence > 0.9;

Compiles to

{
  "operation": "DISCOVER_ENTITIES",
  "source": {
    "uri": "gs://analytics-exports/2026/",
    "scheme": "gs"
  },
  "where": {
    "type": "compare",
    "column": "confidence",
    "op": ">",
    "value": 0.9
  }
}