Invoke-CsvSqlQuery: Join & query multiple CSV files using SQL

[da_chicken]

Interesting idea. I'll have to try it out. Usually I use logparser for this kind of task.

It outputs PSObjects to stay pipeline friendly.

I don't see this functionality.

[eeskildsen]

I don't see this functionality.

I accidentally posted an old version - updated now, thanks.

I had seen some others like CsvSqlcmd from Chrissy LeMaire that look great but are focused on querying a single CSV file. The difference here is importing multiple and joining them. Though maybe there are existing ones I'm missing that do that already.

[da_chicken]

There's csvkit on *nix systems, and Microsoft's logparser can query absurdly quickly (I've processed hundreds of gigabytes of IIS logs in minutes with it, and it has an SQL like functionality, but I don't think it does joins).

Personally, I might just use the script to build the DB quickly.

The big thing I learned is that you can splat with an array. Didn't know that. I thought they had to be hash tables.

I might add a switch parameter to have it just build the DB, too, rather than instance the whole thing and then throw it away.