Import node common properties

Properties that are common to most import nodes are listed below, with information on specific nodes in the topics that follow.

Example

# This example changes a table to another table under the same connection in a Data Asset Import node
import modeler.api
stream = modeler.script.stream()
dataassetImport = stream.findByType('dataassetimport', None)
# the user_settings in data asset import node for database table asset 
#{"interactionProperties":{"read_mode":"general","schema_name":"RQT23321","table_name":"another_table"}}
dataassetImport.setPropertyValue("user_settings", "{\"interactionProperties\":{\"read_mode\":\"general\",\"schema_name\":\"RQT23321\",\"table_name\":\"test\"}}")
Table 1. Import node common properties
Property name Data type Property description
asset_type DataAsset
Connection
Specify your data type: DataAsset or Connection.
asset_id string When DataAsset is set for the asset_type, this is the ID of the asset.
asset_name string When DataAsset is set for the asset_type, this is the name of the asset.
connection_id string When Connection is set for the asset_type, this is the ID of the connection.
connection_name string When Connection is set for the asset_type, this is the name of the connection.
connection_path string When Connection is set for the asset_type, this is the path of the connection.
user_settings string Escaped JSON string containing the interaction properties for the connection. Contact IBM for details about available interaction points.

Example:

user_settings: "{\"interactionProperties\":{\"write_mode\":\"write\",\"file_name\":\"output.csv\",\"file_format\":\"csv\",\"quote_numerics\":true,\"encoding\":\"utf-8\",\"first_line_header\":true,\"include_types\":false}}"

Note that these values will change based on the type of connection you're using.