qascade / dcr

A PoC framework to orchestrate interoperable Differentially Private Data Clean Room Services using Intel SGX hardware as root of trust.
GNU Affero General Public License v3.0
19 stars 16 forks source link

feat: Clean Room Service should spin up a Trusted Container(Simulated) with ZetaSQL engine running inside the enclave #21

Closed qascade closed 1 year ago

qascade commented 1 year ago

Description

Implement a Dockerfile that generates a Linux-sgx container with a ZetaSQL engine inside an enclave. We also need a container server inside the enclave that acts as a gateway between ZetaSQL and the Clean Room Service. This server is under development in issue: #20 by @qascade and @ShisuiMadara.

spec doc: https://www.notion.so/Solution-3-07d81059daab40cb84180336a33c3dd9 under Trusted Env section.

How are you planning to resolve on this issue?

TBD. Please write it in the spec docs and get it signed off.

tipped73 commented 1 year ago

ZetaSql engine doesnot have any examples where they use join queries. ZetaSql is not building as well. We may have to look into the possibility of modifying the zetasql examples after resolving the build issues.

qascade commented 1 year ago

This issue has been discussed. We may need to build our own custom solution on supporting DP SQL queries as a transformation in dcr.

qascade commented 1 year ago

Closing this as completed in a separate repo