bigfunctions > get_latest_partition_timestamp

get_latest_partition_timestamp

Signature

get_latest_partition_timestamp(fully_qualified_table)

Description

Return the maximum of the partition column of fully_qualified_table

Examples

EUUSeurope-west1

call bigfunctions.eu.get_latest_partition_timestamp("my_project.my_dataset.my_table");
select * from bigfunction_result;

call bigfunctions.us.get_latest_partition_timestamp("my_project.my_dataset.my_table");
select * from bigfunction_result;

call bigfunctions.europe_west1.get_latest_partition_timestamp("my_project.my_dataset.my_table");
select * from bigfunction_result;

+----------------------------+
| latest_partition_timestamp |
+----------------------------+
|         2023-01-10         |
+----------------------------+