Sample Schema

sample_schema_2.json

{
   "name":"example schema",
   "description":"example schema with 1 table",
   "workspaceID":"TODO",
   "vaultSchema":{
      "schemas":[
         {
            "name":"persons",
            "fields":[
               {
                  "name":"skyflow_id",
                  "datatype":"DT_STRING",
                  "tags": [
                     {
                         "name": "skyflow.options.data_type",
                         "values": [
                             "skyflow.SkyflowID"
                         ]
                     }
                  ]
               },
               {
                  "name":"age",
                  "datatype":"DT_INT32"
               },
               {
                  "name":"ssn",
                  "datatype":"DT_STRING",
                  "tags":[
                     {
                        "name":"skyflow.options.replace_pattern",
                        "values":[
                           "XXX${1}XX${2}${3}"
                        ]
                     },
                     {
                        "name":"skyflow.options.format_preserving_regex",
                        "values":[
                           "^[0-9]{3}-[0-9]{2}-([0-9]{4})$"
                        ]
                     },
                     {
                        "name":"skyflow.options.default_dlp_policy",
                        "values":[
                           "REDACTED"
                        ]
                     },
                     {
                        "name":"skyflow.options.operation",
                        "values":[
                           "EXACT_MATCH"
                        ]
                     },
                     {
                        "name":"skyflow.options.find_pattern",
                        "values":[
                           "^[0-9]{3}([- ])?[0-9]{2}([- ])?([0-9]{4})$"
                        ]
                     },
                     {
                        "name":"skyflow.options.default_token_policy",
                        "values":[
                           "FORMAT_PRESERVING_TOKEN"
                        ]
                     },
                     {
                        "name":"skyflow.validation.regular_exp",
                        "values":[
                           "^$|^([0-9]{3}-?[0-9]{2}-?[0-9]{4})$"
                        ]
                     }
                  ]
               },
               {
                  "name":"marital_status",
                  "datatype":"DT_STRING",
                  "tags":[
                     {
                        "name":"skyflow.validation.predefinedvalues",
                        "values":[
                           "UNSPECIFIED_MARITAL_STATUS",
                           "ANNULLED",
                           "DIVORCED",
                           "SEPARATED",
                           "MARRIED",
                           "UNMARRIED",
                           "WIDOWED"
                        ]
                     },
                     {
                        "name":"skyflow.options.default_token_policy",
                        "values":[
                           "RANDOM_TOKEN"
                        ]
                     },
                     {
                        "name":"skyflow.options.default_dlp_policy",
                        "values":[
                           "REDACT"
                        ]
                     },
                     {
                        "name":"skyflow.options.operation",
                        "values":[
                           "EXACT_MATCH"
                        ]
                     }
                  ]
               }
            ],
            "childrenSchemas":[
               {
                  "name":"name",
                  "description":"",
                  "fields":[
                     {
                        "name":"first_name",
                        "datatype":"DT_STRING",
                        "tags":[
                           {
                              "name":"skyflow.options.default_token_policy",
                              "values":[
                                 "RANDOM_TOKEN"
                              ]
                           },
                           {
                              "name":"skyflow.options.operation",
                              "values":[
                                 "EXACT_MATCH"
                              ]
                           }
                        ]
                     },
                     {
                        "name":"last_name",
                        "datatype":"DT_STRING",
                        "tags":[
                           
                        ]
                     }
                  ]
               }
            ]
         }
      ]
   }
}