QUERIED_TABLE_INCOMPATIBLE_WITH_ROW_LEVEL_SECURITY_POLICY error class

  • Article

SQLSTATE: 428HD

Unable to access referenced table because a previously assigned row level security policy is currently incompatible with the table schema; to continue, please contact the owner of the table to update the policy:

ARGUMENT_NOT_FOUND_IN_TARGET_TABLE

For target table <tableName>, the row level security policy named <functionName> is implemented by a SQL UDF with <argumentDescription> not found in the target table: (<columnNames>)

DUPLICATE_INPUT_COLUMN_NAMES

For target table <tableName>, the row level security policy named <functionName> is implemented by a SQL UDF with duplicate input column names: (<columnNames>)

INCOMPATIBLE_COLUMN_TYPES

For target table <tableName>, the row level security policy named <functionName> is implemented by a SQL UDF with <argumentDescription> incompatible with the target table: (<columnNames>)

NON_BOOLEAN_RETURN_TYPE

For target table <tableName>, the row level security policy named <functionName> is implemented by a SQL UDF with a non-boolean return type of <returnType>

NO_PARAMETERS

For target table <tableName>, the row level security policy named <functionName> is implemented by a SQL UDF with no parameters

NO_RETURN_TYPE

For target table <tableName>, the <entity> named <functionName> is implemented by a SQL UDF with no return type