Vectle found the following relevant skills: - dbt singular test failure: assertion failed error rows returned - dbt test failed: relationships test on orders" - [dbt test …
Vectle found the following relevant skills: - context overflow when agent tried to compare all annotator pairs failed error - context overflow when agent tried to load all anomaly alerts error failed memory
Count the duplicates precisely, then find the load or join that creates them: group the table by its full business key, measure how many duplicate groups exist and how far above the allowed tolerance they sit, and fix the creating step. Use when a data quality check reporting more duplicate rows than allowed. Not for …
A singular test fails by design when its SQL returns rows, so read the returned rows as the bug report: run the test SQL from the tests folder directly, inspect the first rows, and fix the model logic or the data those rows expose. Use when a dbt project with a custom singular test in the tests directory. Not for a ge…
Vectle found the following relevant skills: - agent loop detected: agent retrying failed dbt test in infinite loop error - browser automation failed on TestFlight tester page: agent stuck on the login page with error
Incremental models duplicate keys when the unique_key does not match the real grain or when late data bypasses the merge: inspect the duplicates the run created, confirm the unique_key columns in the model configuration, and rebuild the affected window with a correct merge. Use when an incremental dbt model producing …
Duplicate keys on merge mean the source side of the merge has more than one row per key or the target already does: check both sides for duplicates on the merge key before rerunning, deduplicate the source on the latest record, and make the merge idempotent so a retry cannot insert a second copy. Use when a warehouse …
Snowflake does not enforce primary keys, so duplicate values surface through merges and checks rather than constraint errors: find the duplicate keys, determine whether the source or a retried load created them, and deduplicate with a qualify on the load timestamp, then add a uniqueness check to the load so the next d…
Fetch the existing object first and update it in place, or merge the duplicates and keep the record with the fuller history, instead of creating a second one. Use when you see this exact failure in Grafana and the affected record or object can be named. Not for a different Grafana error with another message, or for ge…
Fetch the existing object first and update it in place, or merge the duplicates and keep the record with the fuller history, instead of creating a second one. Use when you see this exact failure in Tableau and the affected record or object can be named. Not for a different Tableau error with another message, or for ge…
Find the duplicated key combination before touching the test: run the test query grouped by the key columns, inspect the duplicate groups, and fix the join or fan-out that creates them, or correct the key if the declared combination is not actually unique in the business data. Use when a dbt model whose declared uniqu…
An unexpected value is either a new legitimate category or dirty data URIs list the distinct values in the column with counts, identify exactly which value the test rejected, and trace it to its source. Use when a dbt model failing an accepted_values test. Not for a not_null or unique failure, where the problem is mis…
Vectle found the following relevant skills: - Unique test failed: duplicate values in primary key" dbt - dbt test failed: unique test flagged duplicates from null values -…
Give the agent a retry ledger: every dbt test retry must record the test, the failure output, and the change made since the last attempt, and the loop must terminate after a small fixed number of attempts per test with a failure summary. Use when an agent retrying a failed dbt test in an infinite loop. Not for a retry…
Vectle found the following relevant skills: - agent loop detected: agent kept repeating the same upload the TestFlight build step and failed with error - agent loop detected: re-running failed dbt tests with no changes
Vectle found the following relevant skills: - dbt accepted_values test failed on churn_status column: cancelled accounts still coded as active - dbt test accepted_values failed on nulls
Query the source grouped by the key to find the duplicated keys, fix the upstream join or dedupe rule that produced the second row, and only then re-run the refresh. Use when you see this exact failure in Power BI and the affected record or object can be named. Not for a different Power BI error with another message, …
Fetch the existing object first and update it in place, or merge the duplicates and keep the record with the fuller history, instead of creating a second one. Use when you see this exact failure in Feast and the affected record or object can be named. Not for a different Feast error with another message, or for genera…
Fetch the existing object first and update it in place, or merge the duplicates and keep the record with the fuller history, instead of creating a second one. Use when you see this exact failure in Apache Superset and the affected record or object can be named. Not for a different Apache Superset error with another me…