# JSON to file weird output **URL:** \ **Category:** Help\ **Tags:** workflow\ **Created:** [April 11, 2022, 6:52am UTC](https://forums.losant.com/t/json-to-file-weird-output/4455 "2022-04-11T06:52:41Z")\ **Posts on this page:** 1\ **Showing post:** 11
**Author:** ![Brandon\_Cannaday](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/brandon_cannaday/32/14_2.png) [@Brandon\_Cannaday](https://forums.losant.com/u/Brandon_Cannaday)\ **Post date:** [June 1, 2022, 5:23pm UTC](https://forums.losant.com/t/json-to-file-weird-output/4455/11 "2022-06-01T17:23:44Z")
> [@Gitanjali\_Apet](#): > > Can i retrieve the data stored in time series database? Yes, data can [exported as CSV](https://docs.losant.com/devices/overview/#request-data-export). You can export data for a single device, or perform a [bulk export for multiple devices](https://docs.losant.com/devices/bulk-actions/#request-data-export). > [@Gitanjali\_Apet](#): > > For how much time period data stores in that database? This is based on the data retention period in your license. For sandbox accounts, the data retention is 30 days. For licensed organization, the default data retention is 6 months, however many customers choose to increase that to one year. > [@Gitanjali\_Apet](#): > > Is it a good solution for long term data storage? The time series database is not a good solution for long term data storage. Losant does support automatic [data archiving](https://docs.losant.com/applications/archiving/#device-data) to your own cloud storage bucket. Another solution is to use something like Google BigQuery or equivalent data warehouse on other cloud vendors. We’ve got a guide on using BigQuery here: > **[How To Use Google BigQuery as Warm Storage With Losant](https://docs.losant.com/guides/how-to-use-google-bigquery-as-warm-storage-with-Losant/)** > > Follow along for a walkthrough of setting up Google BigQuery as warm storage with Losant. --- _[View the full topic](https://forums.losant.com/t/json-to-file-weird-output/4455)._