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?
@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.
@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.
@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
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 ?
@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.
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 ?
