@Piotr Tutakโ , I believe you don't need Snowflake at all - just use source files / events from your Data Lake / message brocker to process it whithin Databricks. Auto-loader that might be combined with DLT.
How to + demo.
Auto loader doc
DLT doc
With Auto loader you'll benefit also from the possibility to work in streaming mode and switch to batch if needed. DLT allows to guarantee data quality. Obviously much more value added features might be listed here if we compare vs snowpipe. Among them you'll be able to estimate and control costs - something that is still not possible with snowpipe, unfortunately.