Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 12:00 AM
In DLT, you can achieve similar functionality to the ROW_NUMBER() function in SQL by using the ROW_NUMBER() window function within your DLT pipeline. This can be done using PySpark or SQL syntax within your DLT pipeline code.
CREATE MATERIALIZED VIEW bronze_dlt AS
SELECT
*,
ROW_NUMBER() OVER (ORDER BY column1) AS row_number
FROM
test_wk.default.source_table
--------------------------
Takuya Omi (尾美拓哉)
Takuya Omi (尾美拓哉)
