Is there a way to publish data as nvarchar when writing to SQL Server?

[TrifactaUsers]

Currently, it seems I'm only allowed to publish string data as varchar.

[45fbbb55ab1ef273b792 · Accepted solution]

Hi Scott,

Depending on your product version, you can go to

/opt/trifacta/services/data-service/build/conf/vendor/sqlserver/publish-metadata.json

Here you can find the mappings used by Trifacta to convert to SQL Server specific type.

By default you should see this section

{

   "trifactaType": "string",

   "jdbcType": "varchar",

   "vendorTypeList": ["varchar(256)"]

  },

You can change it to

{

   "trifactaType": "string",

   "jdbcType": "varchar",

   "vendorTypeList": ["nvarchar(256)","varchar(256)"]

  },

Trifacta uses the first type defined in vendorTypeList when it is creating tables.

Please also back up the existing /opt/trifacta/services/data-service/build/conf/vendor/sqlserver/publish-metadata.json file just incase.

A Trifacta restart will be needed.