title: Getting all references to a view within a project on BigQuery
body: <p>Given a view or a table, how can I list views and scheduled queries having a reference to it within a project?</p>
  <p>I understand from <a href="https://cloud.google.com/bigquery/docs/information-schema-views" rel="nofollow noreferrer">the documentation</a> that I can do check reference within a dataset with below query, but I'd like to check reference within a project all at once.</p>
  <pre><code>SELECT *
  FROM your_dataset_name.INFORMATION_SCHEMA.VIEWS
  WHERE REGEXP_CONTAINS(view_definition, 'your_dataset_name.your_table_name')
  </code></pre>