trading_partner_sftp

SFTP connection information for a trading partner.

Primary Key:

• trading_partner_sftp_id

Foreign Keys:

• trading_partner_id => trading_partner.trading_partner_id

Indexes:

• trading_partner_sftp_trading_partner_id_hostname_port_usern_idx (Unique) - trading_partner_id, hostname, port, username
• trading_partner_sftp_trading_partner_id_idx - trading_partner_id

Column	Data Type	Nullable	Indexed	Description
trading_partner_sftp_id	bigint	No	Yes	Snowflake ID of the SFTP configuration for a trading partner.
trading_partner_id	bigint	No	Yes	Link to the trading partner record.
hostname	text	No	Yes	-
port	text	No	Yes	-
username	text	No	Yes	-
password	text	No	No	-
private_key_path	text	No	No	-
host_key_path	text	No	No	-
additional_ciphers	text	No	No	-