Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Masking/tokenize data in snowflake Burst mode

Not planned
Chandrasekhar Penchikala User
  • Edited

We see a great benefit to mask/tokenize data in snowflake Burst mode with external functions(custom functions) as part of replication/refresh process to avoid the manual tokenize data row by row data as this effort is more time consuming/slow process. Can you please include this feature as an enhancement.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Pieter Humphrey Fivetranner
    Thank you for submitting your suggestion! We appreciate you taking the time to share your thoughts with us. To help us better understand and evaluate your request, could you please provide more details? Specifically, it would be helpful to confirm if this is an HVR feature request, or for Fivetran.
    Thanks again for your input—we look forward to learning more!

    Best regards,
    Pieter Humphrey
  • Pieter Humphrey Fivetranner
    Thank you for submitting your suggestion! We appreciate you taking the time to share your thoughts with us. To help us better understand and evaluate your request, could you please provide more details? Specifically, it would be helpful to confirm if this is an HVR feature request, or for Fivetran. Thanks again for your input—we look forward to learning more!

    Best regards,
    Pieter Humphrey
  • Mark Van de Wiel User

    Hi Chandra,

    HVR has ColumnProperties CaptureExpression and IntegrateExpression.

    During a refresh it is most efficient to use CaptureExpression. During replication you want to use IntegrateExpression. You can do this quite easily using the Context option. E.g. use "refresh" as context for the action that defines the CaptureExpression, and "!refresh" for the action defining IntegrateExpression.

    Then when you run the refresh you select the context "refresh".

    For your case of course you need a masking solution that gives the same result when run on the source and the target.

    Mark.