Snowflake’s COPY_HISTORY table function (or the COPY_HISTORY view in ACCOUNT_USAGE) lets you query recent load activity—including file names and statuses—to determine if a given staged file has already been loaded into a table
SELECT *
FROM TABLE(
INFORMATION_SCHEMA.COPY_HISTORY(
TABLE_NAME => 'ORDERS',
START_TIME => DATEADD(DAY, -1, CURRENT_TIMESTAMP())
)
)
WHERE FILE_NAME = 'orders_20250419.csv';
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1 week, 6 days ago