Create a Data Stream (Integration Hub) type data source
Create a Data Stream (IntegrationHub) type data source record to define what complex data an import set should import from a Data Stream action.
Before you begin
Role required: import_admin and action_designer
Procedure
Navigate to All > System Import Sets > Administration > Data Sources.
Click New.
Complete the form.
| Field | Description |
|---|---|
| Name | A unique name for this data source. |
| Import set table label | A label for the import set staging table to use. |
| Import set table name | The ServiceNow AI Platform uses the label you entered to construct a unique table name. This prevents namespace collision with an already existing table. |
| Type | Data Stream \(Integration Hub\) type data source. |
| Data Stream action |
|
| Connection | Specify the connection alias for the Data Stream action. You can use the default parent alias or select any of its children's aliases. Available child aliases are listed in the menu. This field is only available when the Data Stream action is configured to use a connection alias. For more information, see Create a Connection and Credential alias. |
| Data in single column | Selected to store data in a single column. |
| Use Batch Import | If selected, specifies that loading data should be batched when you select Load data or Test load 20 records.Note: The system keeps records in memory until it receives the number of records specified in the batch size. If the batch size is met, it commits all the records as one batched SQL. If all the records are loaded for the import set, it commits all the remaining records as one batched SQL. Since it keeps the maximum of the batch size records in memory when specified, make sure you set the correct batch size to not cause any out-of-memory issues. |
| Batch Size | Specifies how big the batches should be. Appears only when the Use Batch Import field is selected.The glide.import_set_load_usebatch and glide.import_set_load_batch_size properties affects these fields. The priority order for the properties and fields are as follows: If the property is set, use the property value. If not, use the field value. If neither property is set, use the default batch size of 1000.
|
| Data Stream action inputs | Additional fields may appear, based on the inputs defined in the Data Stream action. |
- Click Submit.
What to do next
Define a transform map for the new data source and run an import.