Skip to content

Instantly share code, notes, and snippets.

@arkadius

arkadius/product-orders-report.sql

Created September 25, 2024 13:49
Show Gist options
  • Save arkadius/55b557c0c46b32c32511fa45069ce091 to your computer and use it in GitHub Desktop.
Save arkadius/55b557c0c46b32c32511fa45069ce091 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
product-orders-report.sql
CREATE TABLE product_orders_report
(
report_id BIGINT,
report_timestamp TIMESTAMP,
report_year_month STRING,
product_id BIGINT,
product_quantity_sum BIGINT
) PARTITIONED BY (report_year_month);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment