The main differences are the following:
- Google Analytics 360 account is not required for Streaming.
- Storing and query processing data collected with Streaming is cheaper.
Streaming collects hit and session data into 2 tables and the tables contain only neccessary information, that significantly decreases BigQuery expenses. Table of Google Analytics export contains over 40 columns with AdSense, AdWords, DoubleClick, etc. data that is rarely required.
- With Streaming you start seeing your data in 5 minutes.
Google Analytics export can take up to 24 hours.