Rishabh-Pandey
Databricks MVP

@dataminion01  Yes, it is possible to use a variable or dynamic file path based on dates in some data processing frameworks , but not directly in static SQL DDL statements like CREATE OR REFRESH STREAMING TABLE unless the environment you're working enabled parameter substitution or dynamic SQL execution.

Rishabh Pandey