Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

where is the best place to get help regarding development/building? I've got my very small changes ready to test (adding an existing column to another table); will post output in thread below.

```
± |master U:2 ✗| → cmake --build .
[  0%] Built target thirdparty_sqlite
[  2%] Built target thirdparty_aws_c_common
[  2%] Downloading: <https://s3.amazonaws.com/osquery-packages/third-party/pre-built/macos-x86_64/openssl-1.0.2o.tar.gz>
Downloading...
Failed to retrieve the file from the given url
&lt;urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1056)&gt;
make[2]: *** [libs/fb/openssl/openssl-1.0.2o.tar.gz] Error 1
make[1]: *** [libs/fb/openssl/CMakeFiles/thirdparty_openssl_downloader.dir/all] Error 2
make: *** [all] Error 2
```

are you sure you're on osquery `master`? what is the most recent commit?

I solved it with <https://stackoverflow.com/a/53310545> ... it was my python3 with the cert issue.

it should not need to download `openssl-1.0.2o.tar.gz`. The commit  `93ceef7e5f1c7e17be63e4d7a58c641bc8031474` should be the most recent

well this is embarrassing ... I had checked out osquery awhile back to build a custom launcher pkg file, and when I checked out osquery for dev changes, I `cd` into the wrong repo :joy: I should get some coffee