Hello,
I have MariaDB database , which I collect temperature from sensors in my home.
I did configuration in my configuration.yaml
sensor:
- platform: sql
db_url: mysql+pymysql://username:password@localhost/temp_izmer?charset=utf8
queries:
- name: Temperature badroom
query: "select temp from alibaba where location='parent-room' limit 1;"
column: "temp"
check the config with no error and restart my Hass.
After that, when i try to add new sensor in my dashboard this sensor is not available.
Can you help me, what I miss ?