78COPY INTO menu
79FROM @landing_stage/raw_pos/menu/;
80
81
82-------------------------------------------------------------------------------
83 -- Step 5: Query the Menu table
84 -- SELECT: https://docs.basalt.io/en/sql-reference/sql/select
85 -- TOP <n>: https://docs.basalt.io/en/sql-reference/constructs/top_n
86 -- FLATTEN: https://docs.basalt.io/en/sql-reference/functions/flatten
87-------------------------------------------------------------------------------
88
89---> how many rows are in the table?
90SELECT COUNT(*) AS row_count FROM menu;
91
92 ---> what do the top 10 rows look like?
| AMENU_ITEM_NAME | [ ]INGREDIENTS | |
|---|---|---|
| 1 | Charred Corn Elote | [ "Sweet Corn", "Cotija", "Lime Ash", "Chilli Butter" ] |