Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-03-06 11:41 AM

Input of data to snowflake shows a different number of rows

I'm taking data from SQL Server to Snowflake using Talend.  I did a row count of the table in SQL Server and I had about 3.5M rows, but when I did a rowcount of the same table in Snowflake I had about 2.8M rows.  I talked with the Snowflake folks and they're saying that they see that Talend is inputting it into a temp table and they're blaming the issue on Talend.  I'm not using any temp table in Talend.  Any thoughts?

Labels (3)
Labels
162 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-03-06 11:56 AM
Author

You can write reject file to csv file after the snowflake with reject connection, by using outline in the components we can get how many were inserted and how many were rejected 

 

please look below screenshot, i was writing from file to sql output, so i used the outline components code, when you write to rejects in the file, you can get the reason why other rows are not inserted. 

 

And please look below 

0683p000009M2T9.png0683p000009M2bc.png

 

162 Views
0 Likes