create streaming table using variable file path

dataminion01
New Contributor II
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"
  );