Attribute Metadata Bulk Updates (Security) - Setup

Create a new stage and upload the stored procedure to enable bulk updates for both core and security attribute metadata.

1. Create a new stage for datapancake files (or use an existing stage)

CREATE STAGE <DATABASE>.<SCHEMA>.DATAPANCAKE_FILES;

For more details on creating a stage, see https://docs.snowflake.com/en/sql-reference/sql/create-stage

2. Copy the Attribute Metadata Bulk Updates (Security) - Procedure DDL

3. Paste the DDL and modify the database, schema name, and DataPancake application database name

4. Execute the create stored procedure statement

5. Verify the stored procedure was created successfully

Next Steps

Attribute Metadata Bulk Updates (Security) - Execute

Last updated