Attribute Metadata Bulk Updates (Core) - Setup

Create a new stage and upload the stored procedure to enable bulk updates for core 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 - Procedure DDL

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

Update the DB and Schema name

Update the DataPancake database application name if you changed the name during install. TODO add circle

4. Execute the create stored procedure statement

5. Verify the stored procedure was created successfully

Next Steps

Attribute Metadata Bulk Updates (Core) - Execute

Last updated