SQLPro icon indicating copy to clipboard operation
SQLPro copied to clipboard

Snowflake: Number of Rows Inserted

Open jim256 opened this issue 4 years ago • 5 comments

I just ran the following query:

INSERT INTO [DATABASE].[SCHEMA].[TABLE]

	SELECT
		*
	FROM
		[DATABASE].[SCHEMA].[OTHER_TABLE]
;

I had truncated the table immediately before, and verified it was empty with a SELECT * on it.

The target table had 0 rows before the insert and 2270614 after it, but the results pane showed 0 were inserted: image

Not sure if this is an issue on Snowflake's end or not.

I would upload or email the log, but it has been a while since I've cleared it out (so it's extremely long and I'm not sure where I can cut things off to still include what's needed) and there are a lot of company IP addresses, table names, database names, etc. in there and I'm afraid I might miss one.

jim256 avatar Apr 10 '20 17:04 jim256