Feed

Fresh from KyK

KyK Trick of the day · Sql · From KyK ·

Use `QUALIFY` when a filter depends on a computed window value.

SELECT customer_id, order_id,
       ROW_NUMBER() OVER (
         PARTITION BY customer_id ORDER BY order_date DESC
       ) AS rn
FROM orders
QUALIFY rn = 1;

KyK Interview question · Original practice · From KyK ·

This question checks whether you can preserve the training feature space.

How would you keep feature transformations consistent during model prediction?

Reference

KyK Concept · From KyK ·

Knowing when an error occurs makes Python debugging more systematic.

Python syntax errors and exceptions occur at different stages

Reference

KyK Daily quiz · What does `pop()` return when called without an index on a non-empty Python list? · From KyK ·

Test your understanding of a common list operation.

What does `pop()` return when called without an index on a non-empty Python list?

Be the first to answer

KyK Trick of the day · Python · From KyK ·

A short example shows the two effects of `pop()`.

items = ["a", "b"]
last = items.pop()
print(last)
print(items)

KyK Concept · From KyK ·

Warehouse sizing should follow workload needs, not habit.

Snowflake warehouse size is a compute choice

Reference

KyK Interview question · Original practice · From KyK ·

Practice choosing the right operation for changing table data.

When would you use Delta Lake MERGE instead of INSERT?

Reference

KyK Concept · From KyK ·

Medallion architecture organizes a lakehouse by data quality.

Databricks medallion layers improve data progressively

Reference

KyK Daily quiz · Which Snowflake clause filters rows after a window function runs? · From KyK ·

Test your knowledge of Snowflake query processing.

Which Snowflake clause filters rows after a window function runs?

Be the first to answer

KyK Vercel · 60-second read · 24 Oct ·

New

Vercel CLI adds team spend management

The Vercel CLI can now show and manage a team’s Spend Management budget with commands such as `vercel budgets`, `vercel budgets set`, and `vercel budgets remove`.

Read it on vercel.com