How to acces to sharded table in specific _TABLE_SUFFIX
I have this
sc <- src_bigquery(project = mi_project_name,
dataset = dataset_name,
billing= billing_project_name,
max_pages = 10)
table_sharded <- sc |> tbl(I("`tabla_sharded_*"))
This works, but I don't know how to filter using something like
table_sharded |>
filter( _TABLE_SUFFIX %in% c ('20240909', '20241010', '20241122'))