Configure - Item Flow

  • Updated

Item Flow Preface

Transferring Items from NetSuite to Snowflake


This process involves moving items from one place called NetSuite to another place called Snowflake. Think of NetSuite as where we find things, and Snowflake as where we keep things safe. 

 

2. Updating Existing Items


If we learn something new about something we already know in Snowflake, we'll add that new information to what we already have. It's like adding new decorations to a picture we already drew. This way, we keep everything up to date and complete.

 

Exploring the Process, Let's dig deeper into how this all works. First, we'll go to NetSuite, find what we need, and then carefully bring it to Snowflake. If we don't have a place for something in Snowflake yet, we'll make a space for it. And if we get new details about things we already know, we'll add those details to our existing information. By doing this, we make sure we know everything we need to know about items or products and keep everything organized.

 

Let us understand the process of its functionality with a step by step guide.

Step 1 (Sources - Export): 

  • [Get NetSuite item details] - This tile will process to extract the items with all the required back-end data with the help of a NetSuite Saved Search.

Step 2 (As shown in image): 

  • [Create items table] - 

         

  • This tile will function to either create the Items table or update the details of the table in Snowflake with the help of an SQL Query. With the help of handlebar editor icon, The SQL Editor will appear on screen to make the amendments as per the individual requirements.

         

  • Once you open the editor, which will look like this (As shown in below image) :

         

  • Image 1 

         

  • On the left hand side of the window is the area where the SQL Query must be edited. Follow these mandatory rules to make the flow works for you.
  • In the red-marked (image 1) area you must replace that value with the table name in your current Snowflake schema.

         

  • These red-marked (image 2) are the main cell values in the table, Which has to be updated as per your individual requirements.
  • Every cell value must be added between “( );” and after every cell value name it is mandatory to add “varchar(256)”. (Remove the one not required)
  • Note: If a cell value name is more than one word (e.g. Company Revenue) Then these two or multiple words must be added inside double quotation (" ").

Step 3 (As shown in image): 

  • [Create new item] - This tile plays a prominent role in importing the customers from NetSuite to Snowflake with the help of an SQL Query.

         

  • Click on the red-marked icon to open the SQL Editor.

         

  • The SQL Editor will appear on the screen and the left hand-side red-marked area is the main area to edit the SQL Query and make the flow work in accordance to your requirements.

         

  • Now let us understand, What needs to be updated in regards to making the flow work in accordance with your requirements. In the image at Red-marked (Image 3) value must be replaced with the table name with your Snowflake database Schema.
  • Image 3

         

  • Every cell value must be added between “( );” and inside “{{record.}}” after the dot is where you must add the corresponding field value name then separate it by comma to add another value. If a value has to be hardcoded to true or false then just write a blank “T” for true & “F” for false. (Remove the one not required)

         

Step 4 (As shown in image): 

  • [Update existing item] - This tile will be responsible for writing back the customer exported confirmation into Snowflake, Which will be helpful in not creating a duplicate customer on the next data process. 
  • It works with the in-built Celigo feature which just works in action to provide back “Update” the defined Mapping fields in the Snowflake. 
  • Click on the red-marked (shown below) to open the Mapping Editor channel.

         

  • Once clicked the above Mapping Icon, It will look like this (shown below)

         

  • The above given image displays the placement of mappings. Left hand side is the source which is sourced from NetSuite in this case. The value must be hard coded here which will be a write-back value into Snowflake.

         

  • Right hand side is the source which is sourced from Snowflake in this case. The value must be added for the field name, Here which will be a write-back value placeholder into Snowflake.

         

 

Following these 4 steps will make your flow completely configurable in respect to your requirements and effectively automate the business data process.