import bigframes.pandas as bpd
import pandas as pd

TABLE_ID = "my_project.my_dataset.test_table"

df = pd.DataFrame(
    {"a": [10, 1, 2], "b": ["Justin", "Alex", "Jim"], "c": ["cat", "dog", "cat"]}
)
bdf = bpd.DataFrame(df)

# First time writing, all good
bdf.to_gbq(TABLE_ID, clustering_columns=["b"])

# Reorder the clustered column b and column c
bdf = bdf[["a", "c", "b"]]

# When replacing and writing, the b and c columns are swapped
bdf.to_gbq(TABLE_ID, if_exists="replace", clustering_columns=["b"])