Create a Snowflake schema
Before you create a Snowflake schema, you must have created a Snowflake database. For more information, see topic Create a Snowflake database.
To create a Snowflake schema:
- In the Snowflake application worksheet area, create a new SQL worksheet.
- In the SQL worksheet, run this command:
CREATE SCHEMA "<database_name>"."<schema_name>";where:-
<database_name>: Is the name of the database you created in Create a Snowflake database.
-
<schema_name>: Is the name of this schema you are creating. If you plan to configure the Reltio Data Pipeline for Snowflake for multiple Reltio tenants in the same Snowflake database, you may find it helpful to use the Reltio tenant name as the schema name.
Tip: Take note of this value. You'll need it in several of the following steps in this section.
-
- In the SQL worksheet, view the Successfully created notification message.