2022.5: Streamlining settings

Blog
438

After updating to 2022.5.03 my ‘Database size’ became unavailable.

Below has been automatically been imported into the integration.

  - platform: sql
    db_url: !secret mariadb_url
    queries:
      - name: 'DataBase size'
        query: 'SELECT table_schema "database", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "value" FROM information_schema.tables WHERE table_schema="home_assistant" GROUP BY table_schema;'
        column: 'value'
        unit_of_measurement: MB

Error:

Logger: homeassistant.components.sensor
Source: components/sql/sensor.py:97
Integration: Sensor (documentation, issues)
First occurred: 08:18:03 (2 occurrences)
Last logged: 08:57:00
Error while setting up sql platform for sensor

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/helpers/entity_platform.py", line 249, in _async_setup_platform
    await asyncio.shield(task)
  File "/usr/src/homeassistant/homeassistant/components/sql/sensor.py", line 97, in async_setup_entry
    name: str = entry.options[CONF_NAME]
KeyError: 'name'

Which ‘name’ is meant in the KeyError?