Bigquery table partition issue

[GoodGuy]

hi,  im newbie here, just try learning bigquery, and sorry for my bad english
i haved tried to different condition for partitioning my dummy date log,
but the table partition seems doesnt work. and number of partition is 0 when im checking on table info log2

my code query is

DROP TABLE IF EXISTS  `belajar-my-project-84215.onbigquery.log2`;

CREATE OR REPLACE TABLE  `belajar-my-project-84215.onbigquery.log2`

PARTITION BY  DATE_TRUNC(date, month)

CLUSTER BY  id AS

SELECT

  id_karyawan AS id,

  tanggal AS date,

  time,

  datetime

FROM

  `belajar-my-project-84215.onbigquery.log1`

WHERE

  tanggal IS NOT NULL;     ---- this make sure the date


and this detail data for log1 and log2 

Table log1

id is int64 have value range 1-5000,
date is date type value range is jan 1 2024 - dec 31 2024, 
time is time type value range is time 24hour, each id have 2-3 value perdate
datetime is datetime type

Table ID

belajar-my-project-84215.onbigquery.log1

Created

Feb 12, 2025, 14:26:25 UTC+7

Last modified

Feb 12, 2025, 14:26:25 UTC+7

Table expiration

Apr 13, 2025, 14:26:25 UTC+7

Data location

asia-southeast2

Default collation

Default rounding mode

ROUNDING_MODE_UNSPECIFIED

Case insensitive

false

Description

Labels

Primary key(s)

Tags

Number of rows

2,620,108

Total logical bytes

79.96 MB

tabel log 2

Table ID

belajar-my-project-84215.onbigquery.log2

Created

Feb 13, 2025, 17:23:28 UTC+7

Last modified

Feb 13, 2025, 17:23:28 UTC+7

Table expiration

NEVER

Data location

asia-southeast2

Default collation

Default rounding mode

ROUNDING_MODE_UNSPECIFIED

Case insensitive

false

Description

Labels

Primary key(s)

Tags

Table Type

Partitioned

Partitioned by

MONTH

Partitioned on field

date

Partition expiration

60 days

Partition filter

Not required

Clustered by

• id

Storage info

Number of rows

220,000

Number of partitions

0