Data pipeline load prefixes a certain column with a underscore when pulling data from netsuite

Data Productivity Cloud
,
1

Hi,
Im not an expert in Netsuite data, but for testing purposes I’ve setup a data pipeline load of Account table from Netsuite to our Snowflake instance.
The pipeline execution loaded the data, but i noticed few issues.

  1. ACCTTYPE column prefixed all the values with a underscore Ex. “_expense”
  2. Not all fields possibly loaded. Account Display Name.

I think its off because i also pulled this Account table using powerbi using ODBC driver and the values in Accttype are without the prefix.
For missing fields, in powerbi there is a field that it pulled called “accountsearchdisplayname”, but i don’t see that field getting loaded into snowflake.

My theory is that since powerbi loads using ODBC and matillion data pipeline uses JDBC driver, they may pull different columns?
Does anyone have any insights on this?
Thank you

1 Like
2

Hi @rbaranov

Thank you for your post and welcome to the Matillion Community, its a pleasure to have you here.

I have raised your post with our team to look into this and get you an answer, I will pop a reply back here early next week.

If you need anything else, please do let me know.

Kind regards, Joe

1 Like
3

Hi @rbaranov

I have a few further questions for you please, firstly What data type does NetSuite list the ACCTYPE field as and also regarding the missing fields can you tell me what data types they are too, please?

Thanks Joe