-- run on Athena
create table swh.ctas_license_blobs
with (format='PARQUET') as
select target as sha1_git, from_utf8(name) as name
from directory_entry_file
where
  regexp_like(
    lower(from_utf8(name)),
    '^([a-z0-9._-]+\.)?(copying|licen(c|s)(e|ing)|notice|copyright|disclaimer|authors)(\.[a-z0-9._-]+)?$'
  );
