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 tables can be used as input datasets within the VEIL.AI interface.

💡

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.

If you used the default settings during the installation <app database name> will be VEIL_AI_ANONYMIZATION_ENGINE

2. Grant access using input table reference

For a more guided approach, you can grant access directly within the VEIL.AI app interface:

Launch the app and go to the Create dataset tab.

Go to Create dataset using input table reference.

Click Grant select access.

From the dialog, choose the table(s) you want the application to access.

Once granted, the application will display a list of table references and their aliases.

You can then use one of these aliases to create a dataset from the referenced table—without needing to manually write any SQL.

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