It is! We recently added support for S3 sources [0], which you could use to backfill data and union with a stream.
To your other question, we're currently well-suited for streaming applications. Moving forward, as we add support for features like persistence, we could certainly replace at least parts of a traditional data lake.
To your other question, we're currently well-suited for streaming applications. Moving forward, as we add support for features like persistence, we could certainly replace at least parts of a traditional data lake.
[0]: https://materialize.com/docs/sql/create-source/json-s3/