system.deployment.entity_recreate.dependent_dynamic_table.refresh

This environment variable affects in situations where modified entity has dynamic tables as their direct dependency and the change executed will affect also the dependencies, like ENTITY_RECREATE.

Can be set on environment level with CONFIG_ENVIRONMENT_VARIABLES.

See also:

Notes

By default this variable is set true, but it can be set as false in case this is wanted behavior in the project.

When the variable is set as true and modifications needed for the entity will affect the dependent dynamic tables, the dynamic table will be manually refreshed with syntax:

CODE

ALTER TABLE IF EXISTS <dependent_entity_schema>.<dependent_entity_name> REFRESH

As this manual refresh either succeeds or fails, it is possible to notice from information schema whether the Dynamic table still is functional or have the executed table modifications broken the Dynamic table afterwards with a query similar to this:

CODE

SELECT
  name,
  state,
  data_timestamp
FROM
  TABLE (
    INFORMATION_SCHEMA.DYNAMIC_TABLE_REFRESH_HISTORY (
      NAME => '<dependent_entity_schema>.<dependent_entity_name>',
      RESULT_LIMIT => 1
    )
  )
WHERE state = 'FAILED'