SQLPro
SQLPro copied to clipboard
Snowflake: Number of Rows Inserted
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:
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.