Skip to main content
Skip table of contents

SKIP_STRUCTURE_CHECKING

You are looking at an older version of the documentation. The latest version is found here.

This option controls validation of materialized tables structure. It can have the following possible values:

ValueDescription
TRUEStructure check is disabled; default
FALSEStructure check is enabled

Structure validation algorithm checks correspondence of the materialized table to its source table(s) and whether the materialized table is applicable for further usage. It does this by detecting the following:

  • Changes in the structure (one or more columns could be added, removed, or renamed);
  • Data type mismatch (the type of one or more columns could be changed).

Example

SQL
CALL SYSADMIN.setDefaultOptionValue('SKIP_STRUCTURE_CHECKING', 'FALSE');
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.