# JSON to file weird output

**URL:** <https://forums.losant.com/t/json-to-file-weird-output/4455>\
**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:** 7

<div class="post-metadata">

**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:** [April 11, 2022, 8:21pm UTC](https://forums.losant.com/t/json-to-file-weird-output/4455/7 "2022-04-11T20:21:12Z")

</div>

Losant Data Tables are designed for relatively static data sets. Something like a table that maps fault codes to their description and other meta data.

Data Tables are backed by a database optimized “write light” and “read heavy”. This means data tables can be queried at high rates, but you’ll notice scalability issues if you attempt to continually insert or update data.

If you do want to continually insert data into a database, the recommended approach would be to connect to a managed cloud DB on Azure, AWS, or Google.

For Azure, we’ve got a [guide for using MSSQL](https://www.losant.com/blog/how-to-connect-to-your-azure-mssql-database-with-losant).

For Google BigQuery, we’ve got the built-in [GCP: BigQuery Node](https://docs.losant.com/workflows/data/google-big-query/) and a guide on using it as a [Warm Storage solution](https://docs.losant.com/guides/how-to-use-google-bigquery-as-warm-storage-with-Losant/).

For AWS, I’d recommend using the [AWS Lambda Node](https://docs.losant.com/workflows/data/aws-lambda/) to invoke Lambda functions, which in turn query data from something like [AWS RDS](https://aws.amazon.com/rds/sqlserver/).

If the data you’re receiving is time series data and related to a device, then it should be stored on [Device Attributes](https://docs.losant.com/devices/attributes/). Behind the scenes, all data reported to a device attribute is stored in a time-series database.

---

_[View the full topic](https://forums.losant.com/t/json-to-file-weird-output/4455)._