In Tableau Online, some extracts for Google BigQuery might fail to be refreshed when using Custom SQL.
in Background Tasks for Extracts view, the following error message shows in the details about a task.
The Google BigQuery service was unable to compile the query. Unrecognized name: `CustomSQLQueryName`; Did you mean `CustomSQLQueryName.sql`? at [1:8]