Search for keyword in a table and display filtered results

I am a newbie and trying to build an app where they will see a search box with a label ‘Enter employee ID to search for employee’ and then once an user enters the data (lets say 20 (as employee id), the app would go to a snowflake table (employee), run a query 'select * from employee where emp_id = 20) and display the results to the user. I was able to build a search box using st.text_input but I am unable to understand how to use this value in a query. Can someone help?

Hi @hiphop,

Thanks so much for posting! Can you share the code you’ve written so far? We can point you in the right direction from there