How exactly does the splunk db connect redshift plugin work?

[briancronrath]

It seems incredibly slow loading data in. Is it trying to do it all through a head node? Redshift recommends other methods for timely data loading such as flat file ingestion for speed, just wanted to make sure the plugin wasn't designed to do some fancy magic of this sort and that I'm not missing an option to perform this through dbconnect. Seems that perhaps the Redshift plugin is more suited just for reads?

[jcoates · Accepted solution]

There is no RDS magic - a single Splunk modular input uses JDBC to talk to a single database instance and execute SQL queries.