snowflake storeproc

I am looking for help with a project for a stored procedure in Snowflake from existing sql store procedure. The purpose of the stored procedure is data retrieval, and I need some assistance building out this component. The conditions for data retrieval will depend on the data being retrieved. I am somewhat familiar with Snowflake's capabilities, but I need help to ensure a more efficient and accurate outcome. If you have expertise in writing storeproc for Snowflake, I'd love to hear from you.