Problem insert data bigquery table

Using Streamlit
,
1

hello to all, i have the follow code:

if submit:

query_kai_insert = """
INSERT INTO kaibot-saas-2018.demo.clientes_kai_2024 (id_cliente, nombre_cliente) VALUES ('1', 'acme')
"""

# Ejecutar la consulta
query_job_kai_insert = client.query(query_kai_insert)


st.success('Record added Successfully')

but the query dosen´t works.

if i add the line:
client.commit()

i have the following error:
AttributeError: This app has encountered an error. The original error message is redacted to prevent data leaks. Full error details have been recorded in the logs (if you’re on Streamlit Cloud, click on ‘Manage app’ in the lower right of your app).

can you help me?
thanks for all

2

i have just found the error, was a field problem!!
thanks

1 Like
3

@Delbwick, Glad to hear that it works now!

4

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.