Import node common properties
Properties that are common to most import nodes are listed here, 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\"}}")
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. |