Delphix Products

 View Only

  • 1.  Snowflake Variant Data Type with JSON data

    Posted 10-15-2024 02:47:00 PM

    Hi, I a trying to de-identify json data stored in a variant datatype filed in Snowflake.

    Is there any limitations on variant data type support here ?

    I am thinking I can do unstructured data and apply file format to de-identify JSON data in that field.



    ------------------------------
    Chandrapalred Borra
    TDM Engineer
    HCL America Solutions Inc.
    ------------------------------


  • 2.  RE: Snowflake Variant Data Type with JSON data

    Posted 10-16-2024 04:53:00 AM

    When you edit the ruleset > column you should use in DATA MODEL the Structured > then select JSON and choose the existing file-format for the JSON data.

    https://masking.delphix.com/docs/latest/managing-inventories

    • The database column type should be from one of the following JDBC SQL Types: CHAR, NCHAR, VARCHAR, NVARCHAR, CLOB, NCLOB, LONGVARCHAR, LONGNVARCHAR, BLOB, SQLXML.

    • BLOB type will not be supported for MySQL databases.

    • SQLXML type will be only supported for Oracle databases.

    • The file format must be either XML or JSON.

      It might be that you need to raise a support ticket to request to add that Snowflake specific column type name.
      Otherwise there is a billable Professional Services provided plugin called JSON/JSON2 that can be assigned to any String/Binary compatible column type.



    ------------------------------
    Tino Pironti
    Masking SME
    Technical Manager
    Delphix
    ------------------------------

    Original Message


Related Content