Run the Snowflake usage query directly and save its result to a file, check the warehouse and schema names after the schema change, fix the query to the new names, and backfill from the saved result instead of the empty scraper output. Use when this health scoring, alerting or sync failure repeats on retry and blocks …
Remap the usage history to the new warehouse schema first, then backfill one month at a time, checkpoint each loaded month, and verify row counts per month against the warehouse before loading the next month. Use when this health scoring, alerting or sync failure repeats on retry and blocks account work. Not for platf…
Vectle found the following relevant skills: - agent double-reported the same backup and the dedupe job failed - agent error: failed to dedupe and double deployed the same patch to overlapping waves
Check the warehouse usage export the scraper requested, confirm its date window and schema still return rows in a direct query, fix the export query if the schema moved, and fall back to a direct warehouse export when the scraped export stays empty. Use when this health scoring, alerting or sync failure repeats on ret…
Fixes the request rectification failure address corrected in CRM but warehouse nightly job reverts it by applying the specific fix in the steps, proving it on one small scope first, then rerunning and reconciling counts. Use when this problem blocks a privacy request, export or deletion task. Not for platform wide out…
Update the usage sync column mapping for the renamed Snowflake column, point the sync at the new column name, replay the usage loads missed since the schema change, and verify a named account usage matches a direct warehouse query. Use when this health scoring, alerting or sync failure repeats on retry and blocks acco…
Compare the two copies as data, not as schemas: the uniqueness check passes in the warehouse and fails in the lakehouse copy because the copies differ, through dedup rules, delete handling, or case and padding in keys, so diff the key sets directly. Use when a table replicated between a warehouse and a lakehouse with …
Vectle found the following relevant skills: - agent's scan passed the allowlist but failed production policy: config error - context overflow error when agent tried to load full data quality history into context failed
Normalise before you compare: the duplicate check misses rows that differ only by trailing whitespace because the warehouse comparison treats padded and unpadded strings as different keys, so trim key columns in the check and at ingestion. Use when a uniqueness or duplicate check over string keys fed by padded source …
Vectle found the following relevant skills: - agent loop detected: re-running point in time join after same timestamp error failed - agent loop detected: agent retries failed Hopsworks insert with same duplicate primary keys error
Vectle found the following relevant skills: - parser agent merged two candidates into one record - same name, different emails, no dedup key on file - agent's seat export joined on the wrong key, merged two users into one
Fixes this failure in the seat count reconciliation - agree one seat definition, billed seats from the billing system, and stop the warehouse count of provisioned plus invited users feeding the comparison; republish the corrected count. Prove it on one record, then rerun the full scope and reconcile the counts.
Update the existing tag value in place instead of adding the tag again, or remove that tag key first and then set it, because Unity Catalog allows one value per tag key on a table and a second add for the same key is a conflict. Use when you see this exact failure: Databricks Unity Catalog feature failed error "featur…
Vectle found the following relevant skills: - dbt test failed: unique test flagged duplicates from null values - dbt test failed: unique_combination_of_columns failed with duplicate keys error
Deduplicate the left source on the join keys plus the partition column before the join runs, keeping the latest row per key by event timestamp, because Chronon joins require the left side to be unique on its keys and duplicate keys make the point-in-time result ambiguous. Use when you see this exact failure: Chronon j…
Vectle found the following relevant skills: - dbt test failed: unique_combination_of_columns failed with duplicate keys error - dbt test failed: unique_combination_of_columns failed with duplicate keys error