Add the Predicate to the Metadata File

For a dataset created from a CSV file, you can specify the predicate in the metadata file associated with the CSV file or when you edit the dataset.

You must escape the double quotes around string values when entering a predicate in the metadata file.

In this example, you add the predicate to the metadata file shown below.

{ 
   "fileFormat": { 
   "charsetName": "UTF-8", 
   "fieldsDelimitedBy": ",", 
   "fieldsEnclosedBy": "\"", 
   "numberOfLinesToIgnore": 1 }, 
   "objects": [ 
      { 
         "name": "Targets", 
         "fullyQualifiedName": "Targets",
         "label": "Targets", 
         "rowLevelSecurityFilter": "'AccountOwner' == \"$User.Name\"", 
         "fields": [ 
      { 
         "name": "AccountOwner", 
         "fullyQualifiedName": "Targets.AccountOwner", 
         "label": "Account Owner", 
         "type": "Text" 
      }, 
      { 
         "name": "Region", 
         "fullyQualifiedName": "Targets.Region", 
         "label": "Region", 
         "type": "Text" 
      }, 
      { 
         "name": "Target", 
         "fullyQualifiedName": "Targets.Target", 
         "label": "Target", 
         "type": "Numeric", 
         "precision": 16, 
         "scale": 0, 
         "defaultValue": "0", 
         "format": null 
      }, 
      { 
         "name": "TargetDate", 
         "fullyQualifiedName": "Targets.TargetDate", 
         "label": "TargetDate", 
         "description": "", 
         "type": "Date", 
         "format": "dd/MM/yy HH:mm:ss", 
         "isSystemField": false, 
         "fiscalMonthOffset": 0 
      } 
      ]
      } 
   ]
}