create streaming table using variable file path
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2025 10:32 AM
is it possible to use a variable for the file path based on dates?
files are stores in folders in this format yyyy/mm
CREATE OR REFRESH STREAMING TABLE test
AS SELECT * FROM STREAM read_files(
"/Volumes/.....",
format => "parquet"
);