How to exclude field during ingestion through DB Connect?

[Angelt_3114]

Hey everyone,

I have a couple databases that are being ingested through DB Connect that have an excessive amount of fields, 300+. Some of these fields are not needed, either null or =" ", and was wondering if there is a way to exclude these before or during ingestion. 

Hope everyone has an awesome day!

[Angelt_3114]

oh man! why did I not think of this? lol thank you so much! I started looking for over complicated solutions, instead of simple ones.  

[richgalloway · Accepted solution]

Instead of SELECT * FROM foo, specify the desired fields in the DBX query.  If that's not feasible then use the fields command to keep only the desired fields or discard the excessive ones.