Delphix Products

Hi,

I'm trying to set up profiling on masking engine at data level but can't get the job woking it terminates successfuly but the EMAIL colomns are not tagged as sensitive one.

I'm using this regexp to profile email addresses
\b[[:alnum:]]([-_.]?[[:alnum:]])*@[[:alnum:]]([-.]?[[:alnum:]])*\.([a-z]{2,4})\b

The list of email address to profile are (found on medical_records and patient tables of the demo delphix schema)

Regards,

Mouhssine">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1594641/RackMultipart20170510-13298-1i0il8l-profiled_tables_inline.PNG?1494430031">
#DemoEnvironment
#Masking

Hi Mouhssine,
Does "- \b[[a-zA-Z0-9]]([-_.]?[[a-zA-Z0-9]])*@[[a-zA-Z0-9]]([-.]?[[a-zA-Z0-9]])*\.([a-z]{2,4})\b" work?

Hi Jaclyn, Will give it a try and keep you informed, but I think I tested it first with no success. So please bear with me time to try again and give a feed-back Mouhssine

Hi Jaclyn,

After testing this new regexp nothing new happen i still can't profile emails.

Email reg


Profile


Profiler job


Results (2 tables profiled)



But no column has been identified as sensitive even we have one email column defined per table



Regards,

Mouhssine

Hi Jaclyn,

I fixed it.

After discussing with kersten about this issue he gaves me some great advices, and foud that my profiling dont tag the column because of the sampling algorithm it uses.

To be more clear, the profiler will relay on a configuration file that fixes some key values (NO_OF_ROWS and PERCENTAGE_REQUIRED=80). So this mean that it will look for NO_OF_ROWS that defaults to 100 insied the columns to profile and should find out opf theme at least 80% that matches the regexp defined.

I finally updates my tables to get 100 recored and used this regexp "\b[[a-zA-Z0-9]]([-_.]?[[a-zA-Z0-9]])*@[[a-zA-Z0-9]]([-.]?[[a-zA-Z0-9]])*\.([a-z]{2,4})\b" and voilà things works magically.

Regards,

Mouhssine

I'm glad it's all worked out!