Delphix Products

 View Only
  • 1.  Parque file -- Profiler

    Posted 06-16-2023 01:44:00 AM

    Hi All,

    Could you please let me know, can we run data profiler to identify the sensitive elements in a Parque file.

    Kindly let us know the possible solutions to achieve this.

    Looking forward to hearing back from you.

    Thanks

    Vinoth



    ------------------------------
    Vinoth Gopi
    TDM Consultant
    TATA Consultancy Services Ltd
    ------------------------------


  • 2.  RE: Parque file -- Profiler

    Posted 06-16-2023 03:05:00 AM

    Hi Vinoth,

    Thanks for reaching out to the community. Do you mean Apache Parquet formatted files?

    Best regards.

     



    ------------------------------
    Luke Moss
    Senior Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Parque file -- Profiler

    Posted 06-18-2023 11:17:00 PM

    Hi Luke,

    Yes. It's Apache Parquet formatted files.

    Could you please let us know the feasibility

    Thanks

    Vinoth.



    ------------------------------
    Vinoth Gopi
    TDM Consultant
    TATA Consultancy Services Ltd
    ------------------------------



  • 4.  RE: Parque file -- Profiler
    Best Answer

    Posted 06-19-2023 09:38:00 AM

    Hello Vinoth,

    Unfortunately this is not available as an integrated Masking solution.
    The Compliance Engine requires data in human readable format and Parquets are binary.

    It's possible to use pre-post scripts in order to workaround this but as stated, there's currently no out the box solution.

    I hope this helps. 



    ------------------------------
    Luke Moss
    Senior Support Engineer
    Delphix
    ------------------------------



  • 5.  RE: Parque file -- Profiler

    Posted 06-22-2023 11:43:00 PM

    Hi Luke,

    Thanks for the update.

    Could you please let us know any feasible approach in-place that can be used to approach the Paraquet file.

    If there are any documents provided kindly let us know.

    Thanks

    Vinoth Gopi



    ------------------------------
    Vinoth Gopi
    TDM Consultant
    TATA Consultancy Services Ltd
    ------------------------------



  • 6.  RE: Parque file -- Profiler

    Posted 06-25-2023 11:27:00 AM

    HI Vinoth,

    Parquet are compressed file formats.

    Enable hive table on it or import into PostgreSQL as table format whichever is suitable in your available tool stacks. Basically, covert into table format that delphix support. Once you are successful with this You can automate this conversion from file to table and table to parquet again using hookscirpts as Luke recommended.

    You can also utilize sqoop for this export and import and later configure sqoop bash scripts in hooks.

    Regards,

    Madhav



    ------------------------------
    Madhava Agumbe
    Delphix Arhictect
    Virtusa
    ------------------------------



  • 7.  RE: Parque file -- Profiler

    Posted 06-26-2023 01:16:00 AM

    Hi Madhava,

    Thanks for the update.

    We will give a try and let you know if there any challenges.

    Thanks

    Vinoth



    ------------------------------
    Vinoth Gopi
    TDM Consultant
    TATA Consultancy Services Ltd
    ------------------------------