dbt-data-privacy

This dbt package enables us to protect out customers' privacy on warehouse.

• Installation Instructions
• Requirements
• Supported warehouses
• Generic tests
  • Data Loss Prevention
• Macros
  • Pseudonymization
    • sha256
    • sha512
    • extract_email_domain
  • Code generation
    • generate_privacy_protected_models

Installation Instructions

COMING SOON

Requirements

• dbt-core: 1.6 or later

Supported warehouses

We support only BigQuery at the moment. But, the implementation can be extended to other warehouses by following the manner of dbt package development.

• BigQuery

Generic tests

Data Loss Prevention

COMING SOON

Macros

Pseudonymization

sha256

Computes the hash of the input using the SHA-256 algorithm.

Usage:

SELECT
  {{ dbt_data_privacy.sha256("column_a") }} AS column_a,

sha512

Computes the hash of the input using the SHA-512 algorithm.

Usage:

SELECT
  {{ dbt_data_privacy.sha512("column_a") }} AS column_a,

extract_email_domain

Computes the hash of the input using the SHA-512 algorithm.

Usage:

SELECT
  {{ dbt_data_privacy.extract_email_domain("email_column") }} AS email_column,

Code generation

Generate privacy-protected dbt models