Given the requirements, I think you'll be far happier starting in Microsoft Fabric than in Azure Synapse Analytics. (I can see most Azure Synapse Analytics work migrating to Microsoft Fabric in the future anyway).
You can store your data in One Lake and manipulate it with either SQL or Spark / Python.
Another option to consider is a Kusto database in Fabric. It works really well with streaming data input.