RCG Snowflake System API - Implementation Template

Each implementation template relies on services or data in order to function.

Please review the use cases described on the MuleSoft Accelerator for Retail solution pages for more information about dependencies on other APIs and services.

The following example shows how to create Loyalty and Subscription records in a Snowflake instance.

Prerequisite set up

1. Create a Snowflake instance (account). Go to the Classic Console to create a database, schema, and load a table.
   
   
   
   
2. To create a database, click Database > Create a new database.
   
   
   
   
3. Enter RETAIL_DB as the name and click Finish.
   
   
   
   
4. To create a schema, click RETAIL_DB > Schemas > Create a new schema.
   
   
   
   
5. Enter CUSTOMER as the schema name and click Finish.
   
   
   
   
6. To create a table, click Tables > Create a table > Schema Name > Add Column names > Finish.
   
   
   
   
   
   
7. Click the table name and load any desired mock data by clicking Load Table:
   
   
   
   a. In the Warehouse tab, select the Warehouse and click Next.
   
   
   
   b. In the Source Files tab, select Load files from your computer, click Select Files, select the files to upload and click Next.
   
   
   
   
   
   c. In the Load Options tab, select the location from which to load files, such as Continue loading valid data from the file and click Next.
   
   
   
   d. View the load results and click OK.
   
   
   
   
8. To view the loaded data, run a SQL query from Worksheet:
   
   
   
   

Note: Tables can also be created by running SQL queries in src/main/resources/snowflake_queries.txt.