snowflakedefinitiveguide / 1st-edition Goto Github PK

CREATE OR REPLACE FUNCTION FACTORIAL(n variant)
RETURNS variant LANGUAGE JAVASCRIPT AS
'var f=n;
for (i=n-1; i>0; i--) {
f=f*i}
return f';

The reason the above code works is because snowflake has in built function factorial. If you rename the function to Factorial_gt and run it like:
CREATE OR REPLACE FUNCTION FACTORIAL_GT(n variant)
RETURNS variant LANGUAGE JAVASCRIPT AS
'var f=n;
for (i=n-1; i>0; i--) {
f=f*i}
return f';
and try running it using SELECT FACTORIAL_GT(5)
you will get following stacktrace 100132 (P0000): JavaScript execution error: Uncaught ReferenceError: n is not defined in FACTORIAL_GT at 'var f=n;' position 6

The comment for page 65 is the same as the one for line 62. It should say schemas instead of tables.

// Page 65 - Using the SHOW TABLES command to see the details of tables
SHOW SCHEMAS;

The section defines a masking policy, but does not provide the code to apply the masking policy to the table. Something like the following should be added:

ALTER TABLE DEMO7_DB.HRDATA.EMPLOYEES MODIFY COLUMN EMP_ID set masking policy DEMO7_DB.HRDATA.namemask using (EMP_ID, DEPT_ID);

The code for the masking policy namemask is:

CREATE OR REPLACE masking policy DEMO7_DB.HRDATA.namemask
AS (EMP_ID integer, DEPT_ID integer) returns integer ->
CASE WHEN current_role() = 'HR_ROLE'
then EMP_ID WHEN DEPT_ID = '100'
then EMP_ID
ELSE '**MASKED**' END;

When you select from the table, the following error message is generated:

Numeric value '**MASKED**' is not recognized

It appears the code for the masking policy should be something like:

CREATE OR REPLACE masking policy DEMO7_DB.HRDATA.namemask
AS (EMP_ID integer, DEPT_ID integer) returns integer ->
CASE WHEN current_role() = 'HR_ROLE'
then EMP_ID WHEN DEPT_ID = '100'
then EMP_ID
ELSE -99 END;