Export BLOB feature class attachments to folder

export_attachments.py

from arcpy import da
import os


inTable = r'Database Connections\[email protected]\GISDB.SDE.Canada__ATTACH'
fileLocation = r"C:\Users\AMarinelli\Downloads\blob"

with da.SearchCursor(inTable,['DATA','ATT_NAME']) as cursor:
   for row in cursor:
      binaryRep = row[0]
      fileName = row[1]
      # save to disk
      open(fileLocation + os.sep + fileName, 'wb').write(binaryRep.tobytes())
      del row
      del binaryRep
      del filename