Tim Sweña (Swast)

Update: ```python def visit_FirstNonNullValue(self, op, *, arg): return sge.IgnoreNulls(this=sge.FirstValue(this=arg)) ``` This works for the `bfill` implementation in BigQuery DataFrames. I imagine it should work in most SQLGlot backends. Probably makes...

Thanks for the feature request. I like the idea to mimic the DB-API, though the DB-API diverges from BigQuery syntax since BigQuery's `@` params weren't one of the standard DB-API...

e2e failures: ``` FAILED tests/system/large/blob/test_function.py::test_blob_image_resize_to_series FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_df_where_mask_series FAILED tests/system/large/blob/test_function.py::test_blob_pdf_chunk[True] - ... FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_with_connection[bq_connection] FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_series_apply_array_output FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_df_apply_axis_1_aggregates FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_array_output FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_dataframe_apply_axis_1 FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_df_where_mask FAILED tests/system/large/blob/test_function.py::test_blob_image_resize_to_folder FAILED tests/system/large/blob/test_function.py::test_blob_pdf_chunk[False] FAILED tests/system/large/functions/test_managed_function.py::test_managed_function_options FAILED...

doctest failure: ``` __ [doctest] third_party.bigframes_vendored.pandas.core.frame.DataFrame.join ___ [gw4] linux -- Python 3.12.7 /tmpfs/src/github/python-bigquery-dataframes/.nox/doctest/bin/python 4666 >>> df1.join(df2, how="inner") 4667 col1 col2 col3 col4 4668 11 bar 2 foo 3 4669 4670...

The read client handles reconnection to the server in the following way: https://github.com/googleapis/python-bigquery-storage/blob/1683879b44477ae849f68e350d38143f88b657aa/google/cloud/bigquery_storage_v1/reader.py#L165 I don't think we implemented anything similar for the write API yet. Edit: Potentially, we might want...

> Server might fail before or after handling row and it's not idempotent to send the same message to the different stream. Perhaps @yirutang can comment on this? I see...

I mailed https://github.com/leptos-rs/leptos/pull/4417 to add the homepage to the cargo metadata. Thanks @amanullahmenjli for the pointer!

e2e failures ``` FAILED tests/system/large/functions/test_remote_function.py::test_remote_function_max_instances[set-None] FAILED tests/system/large/functions/test_remote_function.py::test_remote_function_max_instances[no-set] ``` These appear to be unrelated.

Wait for samples tests to pass before merging.

cl/828515544 may be a useful example. that's where I granted the samples tests users permissions. that shouldn't affect doctest, though. doctest should use the compute engine service account from bigframes-dev.