Moving data around in sfdx

gistfile1.txt

# query the data like this gives you a json file
sfdx force:data:tree:export -q "select Bikes_Sold__c, Region__c from Dealer__c" -u cg1 -d data

# Problem: there's no query to CSV for bulk api upsert use.  So we have to parse/convert that json.
# uses npm packages jq and json2csv

# convert to csv for bulk API
cat data/Dealer__c.json | jq .records | jq 'map(del(.attributes))' | json2csv -o data/Dealer__c.csv