Create a Calculation View with Differential Privacy in HANA Cloud

Using what you learned in Create an SAP HANA Database Project, you will create another database table and load sample data into it but without step by step instructions. Extrapolate what you learned from these same steps in the earlier tutorial to complete this task.

1. Create a new database table named TGT_SALARIES using the hdbtable artifact type in the data folder. Use the following table definition.

   column table "TGT_SALARIES" (
       ID INTEGER  unique not null COMMENT 'Employee ID',
       SALARY DOUBLE COMMENT 'Salary',
       START_YEAR INTEGER not null COMMENT 'Starting Year',
       GENDER NVARCHAR(1) COMMENT 'Gender',
       REGION NVARCHAR(4) COMMENT 'Region',
       "T-LEVEL" NVARCHAR(200) COMMENT 'T Level',
       PRIMARY KEY ("ID")
   )
   COMMENT 'Employee Salary'
   

2. Create the configuration for the csv upload. In the data/loads folder, create a file called salaryload.hdbtabledata with the following content

   {
     "format_version": 1,
     "imports": [{
       "target_table": "TGT_SALARIES",
       "source_data": {
         "data_type": "CSV",
         "file_name": "salarydata.csv",
         "has_header": true,
         "dialect": "HANA",
         "type_config": {
           "delimiter": ","
         }
       }
       }]
   }		
   

3. Download this csv file – https://github.com/SAPDocuments/Tutorials/blob/master/tutorials/hana-cloud-calculation-view-differential-privacy/salarydata.csv into your computer. Upload it into the loads folder using the Upload Files option.

4. Save and Deploy these new Artifacts

   

1. Create a view (artifact type hdbview) in the src/data/models folder named V_SALARIES.

   

2. Use the following syntax to create a SQL view that uses the Differential Privacy Anonymization approach for the SALARY column.

   VIEW V_SALARIES (
     ID,
     SALARY,
     START_YEAR,
     GENDER,
     REGION,
     "T-LEVEL"
   ) AS
   SELECT ID,
     SALARY,
     START_YEAR,
     GENDER,
     REGION,
     "T-LEVEL"
   FROM "SALARIES_ANONYMIZED"
   WITH READ ONLY
   WITH ANONYMIZATION (ALGORITHM 'DIFFERENTIAL_PRIVACY'
     PARAMETERS '{"data_change_strategy": "qualified"}'
     COLUMN ID PARAMETERS '{"is_sequence": true}'
     COLUMN SALARY PARAMETERS '{"is_sensitive":true, "epsilon":0.1, "sensitivity":15000}')
   

   For more information about these parameters check the SAP HANA Cloud Data Anonymization Guide

3. If you receive an error that the feature is not supported, this can be safely ignored.

   

4. Save and Deploy

1. Open the Database Explorer for your project

   

2. Open a SQL Console and issue the following statement

   refresh view V_SALARIES anonymization;
   

3. Execute that statement in the SQL console

   

4. You can now use the normal Open Data on the view to preview the Raw Data.