While Reading the Data From Excel query component - and then inserting into a snowflake component -> Do we have to specify each column one by one ? Is there any alternate method ? My excel source contains 200 columns and creating it on the matillion UI is

Matillion ETL
1

While Reading the Data From Excel query component - and then inserting into a snowflake component -> Do we have to specify each column one by one ? Is there any alternate method ? My excel source contains 200 columns and creating it on the matillion UI is very time consuming....

 

0694G00000Ovxu0QAB_0D54G00008v12jsSAA
0694G00000Ovxu0QAB_0D54G00008v12jsSAA1020×612 102 KB

 

0694G00000Ovxu5QAB_0D54G00008v12jsSAA
0694G00000Ovxu5QAB_0D54G00008v12jsSAA728×292 61 KB

 

PS I tried Text mode as well but that doesnt help

2

Hi @azharuddin.mulla​

Please excuse the delayed response. Looking at this question, I am not sure that is possible. You can refer to https://documentation.matillion.com/docs/2503811 try a SELECT * in advanced mode?

Cheers,

Chika

PS: Please circle back and share about the outcome with the Community