package secretflow.scql

Get desktop application:
View/edit binary Protocol Buffers messages

• BROKER_SERVICE_PROTOCOL_V1 = 0

Used in: PrivacyPolicy

• optional ColumnDef col = 1

• string party_code = 2

  the code of party that the constraint applies to.

• Constraint constraint = 3

Used in: ColumnControl

• string column_name = 1

• string table_name = 2

Used in: ColumnControl

• UNKNOWN = 0

• PLAINTEXT = 1

  The column can be revealed at party_code.

• ENCRYPTED_ONLY = 2

  The column or any column produced by it can NOT be revealed at party_code. It can be used as condition in JOIN, WHERE, and GROUP BY.

• PLAINTEXT_AFTER_JOIN = 3

  The column can be revealed at party_code if it is used as join key

• PLAINTEXT_AFTER_GROUP_BY = 4

  The column can be revealed at party_code if it is used as group by key

• PLAINTEXT_AFTER_COMPARE = 5

  The column can be revealed at party_code, if and only if it is the result of the comparison function e.g. select compare1 > compare2 from t group by zip_code

• PLAINTEXT_AFTER_AGGREGATE = 6

  The column can be revealed at party_code, if and only if it has been through a N to 1 mapping such as - Aggregation operation such as sum/min/max/avg/count, e.g. select avg(score) from t group by zip_code select avg(score) from t

• PLAINTEXT_AS_JOIN_PAYLOAD = 7

  The column can be revealed at party_code if it is used as join payload. For example: select t2.id, t2.col1 from t1 inner join t2 on t1.id = t2.id; In the above query, t2.col1 is used as join payload, t2.id is used as join key.

• REVEAL_RANK = 8

  The column is not able to be revealed at the party_code but the rank of this column can be revealed at party_code e.g. SELECT ROW_NUMBER() OVER(PARTITITON BY department ORDER BY salary DESC) AS rank in the query above the salary and department are not supposed to be revealed to the party_code, however the rank of salary in this department is visible

Used in: ScqlTaskInputConfig

• repeated ColumnControl column_control_list = 1

• string project_id = 1

  unique id for scql task, should only contain alphabet and number, e.g: 'project01'

• string query = 2

  scql query, e.g: 'SELECT COUNT(*) FROM ta;'

• map<string, TableList> tables = 3

  tables for each party

• map<string, PrivacyPolicy> ccls = 4

  ccls for each party to grant

• map<string, string> output_ids = 5

  output ids for each party

• string initiator = 6

Used in: ScqlTaskInputConfig

• repeated TableMeta tbls = 1

messages copyed from

Used in: TableList

• string table_name = 1

• string ref_table = 2

• string db_type = 3

• string table_owner = 4

  party code of table owner

• repeated TableMeta.Column columns = 5

Used in: TableMeta

• string name = 1

• string dtype = 2