Why is the refresh status of this table shown in warning state?
The warning sign in the refresh status of a table could mean one of two things. The first possibility is that the query is still in progress and hasn’t fetched all the necessary information yet. In this case, it’s recommended to wait a few minutes before continuing to allow it to complete.
On the other hand, the warning sign could also indicate that the query has failed. There could be various reasons for this, such as a table or dataset from which your table has been imported being deleted or modified. If this occurs, you can try to address the issue by reviewing the changes that were made and running the query again.