MDM Extension for Snowflake > Deploying MDM Extension for Snowflake > Creating a database and schemas in Snowflake
  

Creating a database and schemas in Snowflake

After you download and extract the extension package, run the DDL scripts to create a database and then create staging and analytical schemas in Snowflake.
    1Log in to Snowflake.
    2Create an SQL Worksheet.
    3Navigate to the following file within the extracted extension package:
    <Extracted extension
    package>/1_Snowflake_Staging/Snowflake_Staging.zip/1_db.sql
    4Copy the DDL scripts from the file to SQL Worksheet, and click Run.
    The database, staging schema, and analytical schema are created in Snowflake.
    For more information about staging schema, see Staging schema. For more information about analytical schema, see Analytical schema.