Core + Data Dictionary Attributes - Initialization

Select a stage and upload the stored procedure to enable bulk updates for both core and data dictionary attribute metadata or to generate descriptions, synonyms, and sample values via Cortex AI.

1. (Optional) 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 (Data Dictionary) - 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 (Data Dictionary) - Execute

Last updated