Create a flow definition for a remote table

Build and create a flow for a remote table so that you can retrieve data from an external source with it.

Before you begin

Role required: admin

Procedure

1. Navigate to All > System Definition > Remote Tables > Definition.
   A list of all remote tables definitions shows up.
2. Click New to create a new flow definition.
3. On the form, fill in the fields.

   Control	Description
   Name	Name of the script that you are creating to associate with the selected remote table.
   Table	Name of the remote table that you want to associate the script that you are creating. For a remote table in a scoped application, the name is prefixed with a namespace identifier and the string st_ to indicate that it is remote and part of an application. For a remote table in the global application, the name is prefixed with the string u_st_.
   Flow	Option to build and define your own flow by leveraging the existing functions. Configure the mapping of the flow and tie it to thee required remote table. When the remote table is queried, the flow is triggered and the data is retrieved. See Defining the flow for more information. Note: The Script section doesn't show up when the Flow field has an entry.
   Application	Application that is associated with this remote table. If you are working on an application or are creating a remote table from an application record, the field defaults to that application. Otherwise, the field defaults to Global. Any records that are created from the table record, such as modules and security rules, are assigned to this application by default.
   Active	Option for activating the script that you are associating with the remote table. You can have multiple inactive script definitions for a remote table, but can only have one active script definition.
   Advanced	Option to access the Caching section to designate how the memory caching should operate in the ServiceNow AI Platform for this remote table. Note: Only advanced users should set caching parameters for a remote table.

4. In the Caching section, designate how this data is cached and how long the data is cached in the memory of the ServiceNow AI Platform:

   Field	Description
   Cache TTL	Cache time to live, expressed in seconds, that external data is cached in memory for this remote table script definition. For example, enter 300 to cache the data in the memory for 5 minutes. The maximum value you can enter is 60 minutes (3600 seconds).
   Enhanced Capacity	Option to select the enhanced capacity to support more than 1000 rows in a remote table. Note: If the data size that is retrieved from the external source is small, use the 1000 rows default limit in a remote table to minimize query times. You can select the Enhanced Capacity field if the retrieved data size is large and can be less performative.

   Note:

   By default, the external data is cached in the memory by user.
5. Click Submit.

• Define a flow logic
  Set the triggers and actions to define a remote table flow logic.