A script runs every 15 minutes from cron. Last week one run took 25 minutes, the next one started while it was still going, and both wrote to the same file. How do I stop a second…
QuestionPipelines and Python#cron#schedulingby tom_hartley2 replies
The provider sends a signature header. My framework gives me the parsed JSON by the time my handler runs. If I serialise it again and hash that, the signature never matches. What…
QuestionAPIs and tools#security#webhooksby hannah_weiss2 replies
I am loading a few thousand records from a public API in a loop and after a while every request returns 429. I added time.sleep(1) but it still happens. What is the correct way to…
QuestionAPIs and tools#api#retriesby samir_patel3 replies
I read a CSV exported from our shop. The order_date column looks like 03/11/2025 (day first), but pandas says the type is object and sorting puts 25/12/2025 before 03/11/2025. A…
QuestionPipelines and Python#dates#pandasby lucia_fernandez2 replies
I created this index on a large orders table: CREATE INDEX idx_orders_customer_date ON orders (customer_id, ordered_at); Queries by customer are fast. A report that filters only…
QuestionSQL and databases#indexes#performanceby hannah_weiss2 replies
Our campaign report has Spring_Sale, spring-sale, springsale and spring sale as four different campaigns. Three people create links. What conventions or process actually work?
QuestionAnalytics and measurement#campaigns#utmby jordan_lee3 replies
My load job inserts the previous day's sales into a reporting table. One night it failed halfway, I re-ran it, and now that day has twice the rows and the totals are wrong. I do…
QuestionPipelines and Python#idempotency#pipelinesby chloe_dubois3 replies
I have a script that loads data every few minutes and a second one that updates a status table. When they overlap, one of them fails with sqlite3.OperationalError: database is…
QuestionSQL and databases#locking#sqliteby tom_hartley3 replies
For last month GA4 reports noticeably fewer purchases than the orders table in our shop's database. Revenue is also lower. Should the two match exactly? How would I find out where…
QuestionAnalytics and measurement#ga4#reconciliationby lucia_fernandez2 replies
I have two interviews coming up for junior analyst roles. I can write joins and GROUP BY. Is that enough? What else should I practise?
QuestionCareers and learning#interviews#sqlby chloe_dubois4 replies
I rank students by score with a window function and the numbers skip: 1, 2, 2, 4. I expected 1, 2, 2, 3. SELECT name, score, RANK() OVER (ORDER BY score DESC) AS position FROM…
QuestionSQL and databases#sql#window-functionsby nandini_rao2 replies
I can do pivot tables, lookups and conditional formatting without thinking. Every analyst job I look at asks for SQL, and I do not know where to start. I have a few hours a week…
QuestionQuestions and help#learning#sqlby samir_patel3 replies