If you want it to work with osqueryd you can add

--extensions_autoload=<text file with path to your extension

to your osquery.flags