Hello, I had the same problem (foreign catalog for BigQuery project with limited access) and was able to solve it with the SQL command "REFRESH FOREIGN CATALOG catalog_name". It took a while, but after it finished with "OK", all BigQuery tables could...
Hi Kayla,I know your question is already a year old, but it's possible to create BigQuery tables in Unity Catalog: https://docs.gcp.databricks.com/en/query-federation/bigquery.htmlBest regardsLorenz
