Skip to content

Instantly share code, notes, and snippets.

@yuya-maemichi-synspective

yuya-maemichi-synspective/nonempty-tables.sql

Created October 16, 2023 05:15
Show Gist options
  • Save yuya-maemichi-synspective/2ad13671c6dcd628b90b90b668ca935d to your computer and use it in GitHub Desktop.
Save yuya-maemichi-synspective/2ad13671c6dcd628b90b90b668ca935d to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery snippets
Raw
nonempty-tables.sql
SELECT
*
FROM
`region-asia-northeast1`.INFORMATION_SCHEMA.TABLE_STORAGE
WHERE
total_rows > 0
-- OR total_logical_bytes > 0
-- OR total_physical_bytes > 0
ORDER BY
storage_last_modified_time desc
@yuya-maemichi-synspective
Copy link
Author

ref.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment