---
# System prepended metadata

title: '[data-taster] Sane SQL Sanitization'

---

# [data-taster] Sane SQL Sanitization

1. leverage / clean up ability to determine column names

2. add ability to specify sanitized columns / data in data_taster files

example:
```yml
users:
	"<%= full_table_dump %>"
	sanitization:
		address: "2501 Seaport Dr"

```
3. auto-attempt to sanitize known blocklisted columns:. Ensure that anything specified in the yml files overrides the default sanitization values we set.

```
        * encrypted_*
	* dob / date_of_birth
	* drivers_license
	* ssn
	* email
	* notes
	* etc
```

We can go through these one-by-one, adding a PR, removing the auto-sanitization, and testing for each thing we add.

4. Audit for additional examples