tSQLDWHBulkExec_1 Please create a master key in the database

[Anonymous]

Hi, I am trying to copy data from on-premise to Azure data warehouse.

I follow this article https://www.talend.com/blog/2017/02/08/leverage-load-data-microsoft-azure-sql-data-warehouse-using-p... and create the job look similar to the article provided.

It gave me an error at tSQLDWHBulkExec component with this error:

tSQLDWHBulkExec_1 Please create a master key in the database or open the master key in the session before performing this operation.

Honestly, I am new to both Talend and Azure data warehouse. Do I need to create a master key in the database on azure datawarehouse? With what master key? and do I need to specify that master key somewhere in  tSQLDWHBulkExec_1 component?

[Anonymous · Accepted solution]

Hello,

Please have a look at this reference:https://docs.microsoft.com/en-us/sql/t-sql/statements/open-master-key-transact-sql?view=sql-server-2....

Best regards

Sabrina