You have a database, such as a mysql dump of a Jamf Pro server, or a sql dump of a WordPress site. You want to bring it into another tool or clean the data using a csv as an intermediary. Or you’re using an Amazon Glue job to ETL the data. The following script will take that sql dump and convert it into a bunch of csv files.
To use the script, simply run it with $1 as the path to the sql file and $2 as the path to the export directory, as follows:
python sqlcsvexport.py /sql_file_path /target_dir
To download the script: