Grant Access to input table

After successful installation of the VEIL.AI Anonymization Engine, you need to grant the VEIL.AI Native App access to the tables containing the data you wish to anonymize or synthesize in Snowflake. Once access is granted, these input tables can be utilized by the VEIL.AI Anonymization Engine.

💡

The VEIL.AI Anonymization Engine can not make any changes to the tables or data in your Snowflake databases!

To grant access, you have two options:

1. Grant access using input table name

To provide select access to an input data table, execute the following SQL statements in a worksheet:


GRANT USAGE ON DATABASE <database name> TO APPLICATION <app database name>;
GRANT USAGE ON SCHEMA <database name>.<schema name> TO APPLICATION <app database name>;
GRANT SELECT ON TABLE <database name>.<schema name>.<table name> TO APPLICATION <app database name>;

Replace <database name>, <schema name>, and <table name> with the actual names of your database, schema, and table.

2. Grant access using input table reference

Alternatively, access can be granted using a table reference. Execute the following commands:


SELECT SYSTEM$REFERENCE('table', '<database name>.<schema name>.<table name>', 'persistent', 'select');
CALL <app database name>.SERVICE.REGISTER_REFERENCE('input_table', 'ADD', '<reference>');

Replace <database name>, <schema name>, and <table name> with the actual names.

Replace <reference> with the value returned by the SELECT SYSTEM$REFERENCE function.

The call to REGISTER_REFERENCE returns the <reference_alias> needed to create a dataset.

You are now ready to create and anonymize a dataset with your VEIL.AI Anonymization Engine.

Grant Access to input table 1. Grant access using input table name 2. Grant access using input table reference