Data Features
Data Profiling
Analyze column statistics, data quality scores, pattern detection, and distribution for any BigQuery table.
Running a profile
- Go to Data Profiling in the sidebar
- Select your dataset from the dropdown
- Select a table
- Click Profile Table
Profiling runs 15+ analytical queries against the table. Results appear in 10–30 seconds depending on table size.
Quality dimensions
CompletenessPercentage of non-null values. 100% = no nulls.
UniquenessPercentage of distinct values relative to total rows.
ValidityPercentage of values matching expected patterns (email, phone, UUID, URL).
ConsistencyConsistency of value formats and distributions.
Pattern detection
Datavine automatically detects columns containing emails, phone numbers, URLs, and UUIDs — displayed as badges in the column list. This helps identify PII columns and validate data formats.
Profiling scans the entire table, which incurs BigQuery costs. Use partition filters or sample large tables first.