issue in transpile

[vidit-wisdom]

Fully reproducible code snippet
Code:

import sqlglot
from sqlglot import transpile
print(sqlglot.__version__)

sql = """
SELECT DATEDIFF(days, '2021-01-01', '2021-02-01')
"""
print(transpile(sql, read='redshift',write='bigquery')[0])

Output:

25.1.0
SELECT DATE_DIFF(CAST('2021-02-01' AS DATETIME), CAST('2021-01-01' AS DATETIME), DAYS)

The date interval in the output should be DAY, not DAYS.

Official Documentation
https://count.co/sql-resources/bigquery-standard-sql/date_diff

[vidit-wisdom]

Thanks!