0

I know that many views under SNOWFLAKE.ACCOUNT_USAGE will have a latency, some up to 3 hrs, so is there a way to "force" a refresh of the data, kind of like a ALTER ACCOUNT ... command or ALTER SHARE snowflake...?

I love the concept of checking metadata across all objects in the account but hate knowing some recent changes may not be present.

Felipe Hoffa
  • 54,922
  • 16
  • 151
  • 325
Dave
  • 33
  • 4

1 Answers1

0

Unfortunately, Snowflake does not provide a way to force the refresh of the views in the ACCOUNT_USAGE schema.

Here is a link to the views in the ACCOUNT_USAGE schema as well as their latency times.

In contrast, views/table functions in the Information Schema do not have any latency. They have much shorter retention periods though. Link: Information Schema

Dwayne Brown
  • 11
  • 1
  • there is some mechanism that Snowflake is using to refresh the share SNOWFLAKE so it seems weird to me that it wouldn't be made available. I'm not disagreeing with you, just disappointed I guess. – Dave Jan 04 '21 at 15:19
  • Understandable. It helps to remember that the SNOWFLAKE database in your account is actually an Inbound Share. So that data is being stors/maintained in Snowflake's account. Its just being shared to you. None of that makes it any less disappointing/ frustrating though. – Dwayne Brown Jan 05 '21 at 17:14