Many of our users have indeed asked for tooling to help pipe data from Fauna into data warehouses and OLAP datastores. We understand how important this is and are planning to address these use cases in our upcoming roadmap. Our plan is to provide an data export capability, following the release of our Backup and Restore feature coming this winter. As we currently plan it, this export capability would allow you to export an entire database snapshot to cloud storage, such as AWS S3. You would then be able to seed your OLAP instance from this exported snap. We also pan to expand the capabilities of our Streaming feature so that you can keep your downstream datastore up to date with changes occurring in your Fauna databases.
Further out in the roadmap, we are planning to add a SQL query interface to Fauna that would allow you to connect BI tools such as Qlik, Microstrategy, and Tableau directly Fauna. In general, Fauna is better suited for operational workloads, so using these BI Tools through the SQL query interface isn’t intended to be a full replacement for a data warehouse. However, connecting BI tools through the SQL interface gives you the option serve some reporting or aggregation workloads without the need to move data.
I am eager to answer any questions or comments you have on these forthcoming features. So, please feel free to ping me anytime.