import osquery

if __name__ == "__main__":
    instance = osquery.ExtensionClient('/var/osquery/osquery.em')
    instance.open()

    client = instance.extension_client()
    print(client.query('select * from osquery_schedule'))

worked when i had it set as

/root/.osquery/osquery.em

but returned no results