BigQueryBigQuery is a central platform for modern analytics and data products, but test data is often still managed with ad-hoc SQL and brittle scripts. XDM integrates BigQuery into your enterprise-wide test data strategy, enabling cloning, subsetting and masking across cloud and on-prem systems. Teams work with business-oriented models instead of raw tables, while XDM automates secure, consistent provisioning of BigQuery test data.
With XDM’s modification engine, sensitive data is anonymized or pseudonymized as it flows between BigQuery and other systems, using the same central rules everywhere. Deterministic masking ensures that identical input values are transformed into consistent outputs across tables, projects and even different platforms, preserving referential integrity while remaining GDPR-compliant. Existing BigQuery tables can act as lookup sources for realistic values, and the same mechanisms can be used to generate synthetic test data at scale. This enables you to run realistic analytics and ML tests in BigQuery without exposing production identities or violating internal compliance policies.
Through the Data Shop, even non-technical users can request BigQuery-based test data in their own business language, selecting products, customer groups or time periods instead of thinking in terms of datasets and partitions. Behind each order, an XDM workflow takes care of all technical details, including cross-system selections, masking and imports into the desired BigQuery project or test dataset. Approval steps, execution windows and scheduling can be configured so that heavy BigQuery jobs run at appropriate times without impacting production workloads. This combination of self-service, governance and automation lets organizations leverage BigQuery safely and efficiently as a central analytics backbone for testing and quality assurance.
XDM is a complete test data management platform that enhances agile teamwork, automates test data workflows, and supports multiple databases with secure masking.
Secure sensitive data with XDM’s Masking Tool. Protect privacy and ensure compliance with advanced data masking for all environments.
