mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-07-23 17:30:35 +00:00
18 lines
835 B
Markdown
18 lines
835 B
Markdown
|
## Partitioned Tables
|
||
|
|
|
||
|
|
When profiling **partitioned tables** in BigQuery, OpenMetadata applies a **default partition query duration of 1 day** for time-based partitions. This conservative setting prevents excessive data scans but may result in no **Sample Data** or **Column Profile Metrics** if no data falls within the default window.
|
||
|
|
|
||
|
|
## Resolution
|
||
|
|
|
||
|
|
You can adjust this behavior directly from the UI:
|
||
|
|
|
||
|
|
1. **Navigate to the table's detail page.**
|
||
|
|
2. **Edit the profiler configuration.**
|
||
|
|
3. **Update the `partitionQueryDuration`** under **Partition Config** to a wider window (e.g., 30 days) as needed.
|
||
|
|
|
||
|
|
{% image
|
||
|
|
src="/images/v1.6/connectors/bigquery/partitioned-tables.gif"
|
||
|
|
/%}
|
||
|
|
|
||
|
|
This change allows OpenMetadata to access a broader data range during profiling and sample data collection, resolving the issue for partitioned tables.
|