Fairly new to ES and Kibana. I started migrating some of our IoT Sensor data to ES. Currently 2.5 weeks of data is 17mil records. Currently we use SQL and I am looking at using ES as a primary DB. Here are my questions:
-Can / should I use ES as a primary DB? I found mixed answers online.
-If I shouldn't use it as a primary DB, what would be a good backup / alternative repo.
-Can I run a job and store aggregate values or do you recommend I just query aggregate values in real time?
-Fairly static data like device id's, hardware /firmware versions, lists of assignments to where IoT devices are located, etc, should that be stored in ES or should I use a relationship DB like SQL? If its possible, making ES a "one stop shop" would simplify what I need to manage.
-What kind of security is on ES / Kibana