When exporting data from NetSuite to data bricks using odbc. What query can we use to pull custom field names because currently it only pulls the custom field ids and those are hard to review.

Not sure on odbc but CustomField is exposed to SuiteQL. I think that has what your after.