topic Re: Error while loading a Sample File to Snowflake in Talend Studio

Error while loading a Sample File to Snowflake

Anonymous — Sat, 16 Nov 2024 06:19:44 GMT

I am trying to load a Small CSV file to Snowflake.My requirement is I want to load Customer CSV file to snowflake.I dont have any customer table in my snowflake.Can it create a table and insert data while loading?

Re: Error while loading a Sample File to Snowflake

manodwhb — Fri, 15 Mar 2019 05:27:01 GMT

@asattiraju ,you can only create a table where the sample1 schema and data bases are there. why you have not specified table name in Table section? check @.jpg screenshot.

Re: Error while loading a Sample File to Snowflake

Anonymous — Fri, 15 Mar 2019 05:41:58 GMT

I dont have any Table in my Target DB

Re: Error while loading a Sample File to Snowflake

manodwhb — Fri, 15 Mar 2019 05:47:37 GMT

@asattiraju ,when you were creating a new table you should specify the name,can you give some name and execute the job.when you were not creating a table also you should specify the table name which is already there in DB

Re: Error while loading a Sample File to Snowflake

Anonymous — Fri, 15 Mar 2019 06:11:01 GMT

It Executed when i create a Sample Table and pull that into the Job and transfer data.My question is If we Send an excel/text file to Snowflake without any predefined table in DB .Will it create and load data ?

Re: Error while loading a Sample File to Snowflake

manodwhb — Fri, 15 Mar 2019 06:16:33 GMT

@asattiraju ,great ,until unless you specify the table ,will not create a table there in DB. Please mark the solution and also provide kudos.

Re: Error while loading a Sample File to Snowflake

Anonymous — Fri, 15 Mar 2019 06:20:13 GMT

Hey Manohar,

So if we have n number of files to transfer .We have to have the same structures in Snowflake?

Re: Error while loading a Sample File to Snowflake

manodwhb — Fri, 15 Mar 2019 06:23:54 GMT

@asattiraju ,if your having N.no. of files you can populate to using single job from TOS.

if you have different structure of files and want to load to diff tables you can go with Talend enterprise dynamic schema. where you should read target tables from file or DB ,and you need to iterate where the exact job will take to load into that table.

Re: Error while loading a Sample File to Snowflake

Anonymous — Fri, 15 Mar 2019 06:30:32 GMT

Let me be clear.I think i am confusing you .

I have my source flatfile Orders,I want to transfer it to snowflake DB.

My Requerement

1)I mentioned all my scheme,DB and warehouse name in my TOS and connection is Successful.I dont have any tables as my schema and DB both are new.

2)When i develop a job Source as Flatfile and target is my snowflake.When i run the job ,will the job at the target level create a table Orders and load data into it ?

Re: Error while loading a Sample File to Snowflake

manodwhb — Fri, 15 Mar 2019 06:32:44 GMT

@asattiraju ,you should specify the scehma ,DB and target table. otherwise you wil get the error what you got first time.

Re: Error while loading a Sample File to Snowflake

Anonymous — Fri, 15 Mar 2019 06:35:57 GMT

Agreed.But when I move Flatfile to output flat file in local system.The job is successful and anothe flatfile is created.

Re: Error while loading a Sample File to Snowflake

manodwhb — Fri, 15 Mar 2019 06:41:27 GMT

@asattiraju ,when you drag tFileoutputdemitted to your job ,the file name will get automatically ,which will create in your workspace something like below. but for the DB's you should specify.

C:/TOS_DI-20181026_1147-V7.1.1/workspace/out.csv