tSQLDWHBulkExec_1 Please create a master key in the database

Anonymous — Thu, 02 May 2019 00:50:43 GMT

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-polybase-talend-etl/ 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?

Re: tSQLDWHBulkExec_1 Please create a master key in the database

Anonymous — Tue, 21 May 2019 09:36:42 GMT

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-2017.

Best regards

Sabrina

topic tSQLDWHBulkExec_1 Please create a master key in the database in Talend Studio

tSQLDWHBulkExec_1 Please create a master key in the database

Re: tSQLDWHBulkExec_1 Please create a master key in the database