{"id":6776,"date":"2015-03-20T11:35:17","date_gmt":"2015-03-20T15:35:17","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=6776"},"modified":"2019-11-01T08:53:47","modified_gmt":"2019-11-01T12:53:47","slug":"how-to-mask-cassandra-datastax-with-iri-fieldshield","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/","title":{"rendered":"How to Mask Cassandra with IRI FieldShield"},"content":{"rendered":"<p class=\"western\" lang=\"zxx\"><em><strong>UPDATE: Q2&#8217;17<\/strong>: Included JDBC and ODBC drivers, and pending native JSON handling can make the connections faster and more seamless than the approach shown below. Y<\/em><em>ou can also use the Hadoop edition of <a href=\"http:\/\/www.iri.com\/products\/voracity\">IRI Voracity<\/a> to mask data in HDFS directly. Data exported in the manner below to a flat-file in HDFS can be masked at the field level from the FieldShield module Voracity <a href=\"http:\/\/www.iri.com\/solutions\/big-data\/hadoop-optional\">in the same way<\/a> shown below via MapReduce2, Spark, Spark Stream, Storm or Tez without additional coding.<\/em><\/p>\n<p lang=\"zxx\"><em><strong>UPDATE: Q3&#8217;19<\/strong>: Now available in\u00a0<a href=\"https:\/\/www.iri.com\/products\/darkshield\">IRI DarkShield<\/a> are native out-of-the-box connectors for Cassandra and MongoDB that do not require export\/mask\/import steps, and can handle semi- and un-structured collection data. Like FieldShield, DarkShield is also available (included) in subscriptions to the Voracity platform. See <strong><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/mongodb-cassandra-darkshield\/\">this how-to-article<\/a><\/strong> for finding and masking PII floating in Cassandra NoSQL DBs.\u00a0If you are interested in populating Cassandra with synthetic test data, see <a href=\"https:\/\/www.iri.com\/blog\/test-data\/creating-test-data-for-cassandra-datastax\/\">this article<\/a>.<\/em><\/p>\n<p class=\"western\" lang=\"zxx\">DataStax \/ Cassandra cannot\u00a0mask\u00a0specific\u00a0columns\u00a0to\u00a0stop unauthorized users from seeing personally identifiable information (PII).\u00a0In this article, we will\u00a0show\u00a0how to export data from a Cassandra database to a CSV file, and use the\u00a0<a href=\"http:\/\/www.iri.com\/products\/fieldshield\" target=\"_blank\" rel=\"noopener\">IRI FieldShield<\/a>\u00a0product (also available in the IRI Voracity platform) to randomize, mask, and encrypt the data in\u00a0that CSV file. Then we will import that data back into Cassandra, updated and protected. Another\u00a0article is planned upon release of IRI&#8217;s more direct connection to the DB.<\/p>\n<p class=\"western\" lang=\"zxx\">In\u00a0our example we\u00a0have\u00a0a table with student information in DataStax. The columns are: id_num (the primary key), honors, semester_hours, socsecnum (social security number), and user_id.<\/p>\n<p class=\"western\" lang=\"zxx\">To\u00a0de-identify each\u00a0student, we will randomize their semester_hours, mask their socsecnum, and encrypt the user_id value so that each student&#8217;s PII is protected.<\/p>\n<p class=\"western\" lang=\"zxx\"><span style=\"text-decoration: underline;\"><b>Unprotected data in Cassandra<\/b><\/span><\/p>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6898 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore1-e1426860570382.png\" alt=\"Cassandra_FieldShield_InCassBefore\" width=\"600\" height=\"303\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\"><em>For our command line examples, we are using the <a title=\"DataStax\" href=\"http:\/\/www.datastax.com\/\">DataStax<\/a> Cassandra CQL shell.<\/em><\/p>\n<p class=\"western\" lang=\"zxx\"><span style=\"text-decoration: underline;\"><b>Exporting a Cassandra table to a CSV file<\/b><\/span><\/p>\n<p class=\"western\" lang=\"zxx\">To export a Cassandra table to a CSV file, run\u00a0the following command from the Cassandra CQL shell:<\/p>\n<pre class=\"western\">COPY &lt;Exporting Table&gt; TO '&lt;File Path to the CSV you exporting to&gt;' WITH HEADER=TRUE;<\/pre>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/CassandraExport1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6915 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/CassandraExport1-e1426860581412.png\" alt=\"Cassandra_FieldShield_CassandraExport\" width=\"600\" height=\"300\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\"><strong>Opening and Defining the CSV Source<\/strong><\/p>\n<ol>\n<li class=\"western\">From the top toolbar of the IRI Workbench <a href=\"http:\/\/www.iri.com\/products\/workbench\/fieldshield-gui\" target=\"_blank\" rel=\"noopener\">GUI for FieldShield<\/a>\u00a0(built on Eclipse), find the FieldShield icon and\u00a0select &#8216;New Protect Job&#8217; to run the wizard. Name your job file, &#8220;CassShieldJob.fcl&#8221; and\u00a0click &#8216;Next&#8217;.<\/li>\n<li class=\"western\">Click &#8216;Add Data Source&#8217;, and then &#8216;Browse&#8217; to the CSV file you created with your export. Then click &#8216;OK&#8217;.<\/li>\n<li class=\"western\">Click &#8216;Discover Metadata&#8217; and name the (re-usable data definition file)\u00a0&#8220;StudentsMeta.ddf&#8221; and\u00a0click &#8216;Next&#8217;. Click &#8216;Yes&#8217; to auto-detect and &#8220;Get field names from header row&#8217; before\u00a0clicking &#8216;OK&#8217;, then &#8216;Finish&#8217;.<\/li>\n<li class=\"western\">You should now see your fields in the Data Sources list. Click &#8216;Next&#8217;.<\/li>\n<\/ol>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/DetectLayout.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6900 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/DetectLayout-e1426860594453.png\" alt=\"Cassandra_FieldShield_DetectLayout\" width=\"600\" height=\"321\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\"><strong>Applying the Protections<\/strong><\/p>\n<ol>\n<li class=\"western\">Click &#8216;Add Data Target&#8217; and browse to create a new\u00a0CSV file target to hold the protected version of the data (or\u00a0to overwrite the source, use the same path\/file.\u00a0Then click &#8216;Target Field Layout&#8217;, to review the layout and apply the protections to the output fields. There\u00a0are two list boxes;\u00a0the top shows the source\u00a0fields, and the bottom shows\u00a0the target fields to which you will apply the field &#8220;shields.&#8221;<\/li>\n<li class=\"western\"><span style=\"text-decoration: underline;\">Randomize\u00a0semester_hours<\/span>: \u00a0Select the\u00a0semester_hours field name in the target pane and click &#8216;Field Protection.&#8221; Select Random Value Generation, and for type, select Digit. Set the random minimum and maximum sizes to 2 and click OK.<\/li>\n<li class=\"western\"><span style=\"text-decoration: underline;\">Mask socsecnum<\/span>: Select the socsecnum field and click &#8216;Field Protection&#8217; again. Select Masking, and choose the default USA SSN option to\u00a0expose only\u00a0the last four digits of the SSNs. Click &#8216;OK&#8217;.<\/li>\n<li class=\"western\"><span style=\"text-decoration: underline;\">Encrypt user_id<\/span>: Select the\u00a0user_id and \u00a0click &#8216;Field Protection&#8217; again. Select Encryption and Decryption\u00a0and choose\u00a0enc_fp_aes256_alphanum for <a href=\"http:\/\/www.iri.com\/solutions\/data-masking\/encryption\/format-preserving-encryption\" target=\"_blank\" rel=\"noopener\">format preserving encryption<\/a>.\u00a0Enter a\u00a0passphrase (the decryption key) and in the Exclude box type &#8220;User_&#8221; to prevent the User_ part of our username from being encrypted, Then click &#8216;Finish&#8217;.<\/li>\n<li class=\"western\">The\u00a0fields to be protected should appear as follows:<a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/EncryptDataWindow.png\"><br \/>\n<\/a><\/li>\n<\/ol>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/EncryptDataWindow1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6905 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/EncryptDataWindow1-e1426860609176.png\" alt=\"Cassandra_FieldShield_EncryptDataWindow\" width=\"600\" height=\"536\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\">Click &#8216;OK&#8217;, and then &#8216;Finish&#8217; to\u00a0see the actual (executable job)\u00a0script created for you:<\/p>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/FinalScript2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6906 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/FinalScript2-e1426860622260.png\" alt=\"Cassandra_FieldShield_FinalScript\" width=\"600\" height=\"490\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\">Run the job in the IRI Workbench or on the command line,<\/p>\n<pre class=\"western\" lang=\"zxx\">fieldshield \/spec=CassShieldJob.fcl<\/pre>\n<p class=\"western\" lang=\"zxx\">The CSV file you created\u00a0will\u00a0contain the new masked and encrypted data.<\/p>\n<p class=\"western\" lang=\"zxx\"><span style=\"text-decoration: underline;\"><b>Importing the protected data\u00a0into Cassandra<\/b><\/span><\/p>\n<p class=\"western\" lang=\"zxx\">To import the changed data back into Cassandra, use the following command in the Cassandra CQL shell:<\/p>\n<pre class=\"western\">COPY &lt;Table you are importing data to&gt; (field1fromCSV, field2fromCSV, ...) FROM '&lt;Path to CSV&gt;';<\/pre>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/CassandraImport.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6916 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/CassandraImport-e1426860638992.png\" alt=\"Cassandra_FieldShield_CassandraImport\" width=\"550\" height=\"278\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\"><span style=\"text-decoration: underline;\"><b>Protected data in Cassandra<\/b><\/span><\/p>\n<p class=\"western\" lang=\"zxx\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/InCassAfter1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6907 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2015\/03\/InCassAfter1-e1426860655731.png\" alt=\"Cassandra_FieldShield_InCassAfter\" width=\"550\" height=\"280\" \/><\/a><\/p>\n<p class=\"western\" lang=\"zxx\">For details on FieldShield capabilities, see <a href=\"http:\/\/www.iri.com\/products\/fieldshield\/technical-details\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iri.com\/products\/fieldshield\/technical-details<\/a>.<\/p>\n<p class=\"western\" lang=\"zxx\">\n","protected":false},"excerpt":{"rendered":"<p>UPDATE: Q2&#8217;17: Included JDBC and ODBC drivers, and pending native JSON handling can make the connections faster and more seamless than the approach shown below. You can also use the Hadoop edition of IRI Voracity to mask data in HDFS directly. Data exported in the manner below to a flat-file in HDFS can be masked<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\" title=\"How to Mask Cassandra with IRI FieldShield\">Read More<\/a><\/div>\n","protected":false},"author":61,"featured_media":6760,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[108,8,29,3],"tags":[510,511,512,519,515,516,520,517,148,149,514,518,513],"class_list":["post-6776","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-big-data-2","category-data-protection","category-test-data","category-vldb-operations","tag-cassandra-datastax","tag-cql-shell","tag-csv-file","tag-database","tag-encrypt","tag-export","tag-iri-fieldshield","tag-mask","tag-personally-identifiable-information","tag-pii","tag-protected-data","tag-randomize","tag-unprotected-data"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Mask Cassandra with IRI FieldShield - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Mask Cassandra with IRI FieldShield - IRI\" \/>\n<meta property=\"og:description\" content=\"UPDATE: Q2&#8217;17: Included JDBC and ODBC drivers, and pending native JSON handling can make the connections faster and more seamless than the approach shown below. You can also use the Hadoop edition of IRI Voracity to mask data in HDFS directly. Data exported in the manner below to a flat-file in HDFS can be maskedRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-20T15:35:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-01T12:53:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png\" \/>\n\t<meta property=\"og:image:width\" content=\"678\" \/>\n\t<meta property=\"og:image:height\" content=\"344\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nathan Dymora\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Dymora\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\"},\"author\":{\"name\":\"Nathan Dymora\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa\"},\"headline\":\"How to Mask Cassandra with IRI FieldShield\",\"datePublished\":\"2015-03-20T15:35:17+00:00\",\"dateModified\":\"2019-11-01T12:53:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\"},\"wordCount\":738,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png\",\"keywords\":[\"Cassandra DataStax\",\"CQL shell\",\"csv file\",\"database\",\"encrypt\",\"export\",\"IRI FieldShield\",\"mask\",\"personally identifiable information\",\"PII\",\"protected data\",\"randomize\",\"unprotected data\"],\"articleSection\":[\"Big Data\",\"Data Masking\/Protection\",\"Test Data\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\",\"name\":\"How to Mask Cassandra with IRI FieldShield - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png\",\"datePublished\":\"2015-03-20T15:35:17+00:00\",\"dateModified\":\"2019-11-01T12:53:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png\",\"width\":678,\"height\":344},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Mask Cassandra with IRI FieldShield\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa\",\"name\":\"Nathan Dymora\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g\",\"caption\":\"Nathan Dymora\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/nathand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Mask Cassandra with IRI FieldShield - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/","og_locale":"en_US","og_type":"article","og_title":"How to Mask Cassandra with IRI FieldShield - IRI","og_description":"UPDATE: Q2&#8217;17: Included JDBC and ODBC drivers, and pending native JSON handling can make the connections faster and more seamless than the approach shown below. You can also use the Hadoop edition of IRI Voracity to mask data in HDFS directly. Data exported in the manner below to a flat-file in HDFS can be maskedRead More","og_url":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/","og_site_name":"IRI","article_published_time":"2015-03-20T15:35:17+00:00","article_modified_time":"2019-11-01T12:53:47+00:00","og_image":[{"width":678,"height":344,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png","type":"image\/png"}],"author":"Nathan Dymora","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Dymora","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/"},"author":{"name":"Nathan Dymora","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa"},"headline":"How to Mask Cassandra with IRI FieldShield","datePublished":"2015-03-20T15:35:17+00:00","dateModified":"2019-11-01T12:53:47+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/"},"wordCount":738,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png","keywords":["Cassandra DataStax","CQL shell","csv file","database","encrypt","export","IRI FieldShield","mask","personally identifiable information","PII","protected data","randomize","unprotected data"],"articleSection":["Big Data","Data Masking\/Protection","Test Data","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/","url":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/","name":"How to Mask Cassandra with IRI FieldShield - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png","datePublished":"2015-03-20T15:35:17+00:00","dateModified":"2019-11-01T12:53:47+00:00","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png","width":678,"height":344},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/how-to-mask-cassandra-datastax-with-iri-fieldshield\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Mask Cassandra with IRI FieldShield"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/6c3bde00b144e9786b3d024c1e45defa","name":"Nathan Dymora","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fe3589b371c7912ed817bd9e5e443745?s=96&d=blank&r=g","caption":"Nathan Dymora"},"url":"https:\/\/beta.iri.com\/blog\/author\/nathand\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2015\/02\/InCassBefore.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6776"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=6776"}],"version-history":[{"count":27,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6776\/revisions"}],"predecessor-version":[{"id":13282,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6776\/revisions\/13282"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/6760"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=6776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=6776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=6776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}