Tag
sql
169 pieces tagged “sql”, newest first.
- Keeping one row per key in data-job-postings Analytics engineering
- movie_id is not unique, and the join knows Analytics engineering
- Counting rows is not testing grain Analytics engineering
- A running total that does not lie about ties Analytics engineering
- customer_id is not unique, and the join knows Analytics engineering
- Is resolved_at + ticket_id the grain of support-tickets? Analytics engineering
- A running total that does not lie about ties Analytics engineering
- The total came out 8.2× too high Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Date spine, in short Analytics engineering
- Comparing a period to the one before it Analytics engineering
- The total came out 4.2× too high Analytics engineering
- Is ticket_id + channel the grain of support-tickets? Analytics engineering
- Deduplicate by rank, in short Analytics engineering
- Is posting_id + country the grain of data-job-postings? Analytics engineering
- A running total that does not lie about ties Analytics engineering
- The total came out 1.0× too high Analytics engineering
- Pattern: Deduplicate by rank Analytics engineering
- device_id is not unique, and the join knows Analytics engineering
- Is reading_at + device_id the grain of sensor-telemetry? Analytics engineering
- Sessions out of raw events in retail-orders Analytics engineering
- Is subject_id + arm the grain of clinical-trial? Analytics engineering
- Finding the gaps in ab-test-checkout Analytics engineering
- user_id is not unique, and the join knows Analytics engineering
- One question I ask in every code review Analytics engineering
- Pattern: Conditional pivot Analytics engineering
- Comparing a period to the one before it Analytics engineering
- The total came out 34.6× too high Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Keeping one row per key in retail-orders Analytics engineering
- Is resolved_at + channel the grain of support-tickets? Analytics engineering
- Finding the gaps in saas-subscriptions Analytics engineering
- Is user_id + genre the grain of movie-ratings? Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Is device_id + status the grain of sensor-telemetry? Analytics engineering
- Keeping one row per key in sensor-telemetry Analytics engineering
- Is ticket_id + queue the grain of support-tickets? Analytics engineering
- Keeping one row per key in movie-ratings Analytics engineering
- Is account_id + plan the grain of saas-subscriptions? Analytics engineering
- Is subject_id + sex the grain of clinical-trial? Analytics engineering
- Finding the gaps in data-job-postings Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Is subject_id + site the grain of clinical-trial? Analytics engineering
- Is order_id + line_no the grain of retail-orders? Analytics engineering
- Conditional pivot, in short Analytics engineering
- Sessions out of raw events in ab-test-checkout Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Deduplicate by rank, in short Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Is reading_at + status the grain of sensor-telemetry? Analytics engineering
- Keeping one row per key in ride-hail-trips Analytics engineering
- Is device_id + reading_at the grain of sensor-telemetry? Analytics engineering
- Gaps and islands, in short Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Is user_id + movie_id the grain of movie-ratings? Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Counting rows is not testing grain Analytics engineering
- The left join that became an inner join, in short Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Fan-out join, in short Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Is resolved_at + priority the grain of support-tickets? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Pattern: Date spine Analytics engineering
- Sessions out of raw events in sensor-telemetry Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Is flight_no + carrier the grain of flight-delays? Analytics engineering
- Is posting_id + seniority the grain of data-job-postings? Analytics engineering
- Finding the gaps in city-air-quality Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Sessions out of raw events in saas-subscriptions Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Anti-join, in short Analytics engineering
- Keeping one row per key in support-tickets Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Keeping one row per key in ab-test-checkout Analytics engineering
- Finding the gaps in support-tickets Analytics engineering
- Sessions out of raw events in support-tickets Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Finding the gaps in sensor-telemetry Analytics engineering
- Pattern: Gaps and islands Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Finding the gaps in ride-hail-trips Analytics engineering
- Counting rows is not testing grain Analytics engineering
- A running total that does not lie about ties Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Comparing a period to the one before it Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Sessions out of raw events in ride-hail-trips Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Sessions out of raw events in data-job-postings Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Gaps and islands, in short Analytics engineering
- Finding the gaps in retail-orders Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Finding the gaps in flight-delays Analytics engineering
- Is reading_at + site the grain of sensor-telemetry? Analytics engineering
- Anti-join, in short Analytics engineering
- Is order_id + category the grain of retail-orders? Analytics engineering
- Is user_id + device the grain of ab-test-checkout? Analytics engineering
- Sessionisation, in short Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is posting_id + city the grain of data-job-postings? Analytics engineering
- Writing a SQL engine that fits in a browser tab Visualization
- Is line_no + channel the grain of retail-orders? Analytics engineering
- Date spine, in short Analytics engineering
- Is ticket_id + priority the grain of support-tickets? Analytics engineering
- Is ticket_id + resolved_at the grain of support-tickets? Analytics engineering
- Fan-out join, in short Analytics engineering
- Is movie_id + rated_at the grain of movie-ratings? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Conditional pivot, in short Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is trip_id + payment_type the grain of ride-hail-trips? Analytics engineering
- The `else` branch that ate 4% of revenue Data quality
- Is order_id + country the grain of retail-orders? Analytics engineering
- The left join that became an inner join, in short Analytics engineering
- Pattern: The left join that became an inner join Analytics engineering
- Is movie_id + user_id the grain of movie-ratings? Analytics engineering
- Is device_id + site the grain of sensor-telemetry? Analytics engineering
- Is user_id + rated_at the grain of movie-ratings? Analytics engineering
- Is flight_no + origin the grain of flight-delays? Analytics engineering
- Is line_no + order_id the grain of retail-orders? Analytics engineering
- Sessionisation, in short Analytics engineering
- Is device_id + reading_at the grain of sensor-telemetry? Analytics engineering
- Pattern: Sessionisation Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is account_id + industry the grain of saas-subscriptions? Analytics engineering
- Is flight_no + dest the grain of flight-delays? Analytics engineering
- Pattern: Anti-join Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is line_no + category the grain of retail-orders? Analytics engineering
- Is user_id + exposed_on the grain of ab-test-checkout? Analytics engineering
- Is movie_id + genre the grain of movie-ratings? Analytics engineering
- Is resolved_at + queue the grain of support-tickets? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is user_id + variant the grain of ab-test-checkout? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is trip_id + pickup_at the grain of ride-hail-trips? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is order_id + channel the grain of retail-orders? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is line_no + country the grain of retail-orders? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Is account_id + region the grain of saas-subscriptions? Analytics engineering
- Counting rows is not testing grain Analytics engineering
- Counting rows is not testing grain Analytics engineering
- The join that doubled revenue for six weeks Data quality