How dbt work with database stored procedure and execute sql

have several snowflake database stored procedures. need to figured out how to translate them into dbt.
Is there anyone know what is the dbt component to handle stored procedure and execute sql?
example:
sp:
insert into table 1;
update table 1;
delete form table 1;

want to find a way to execute sp on daily basis. (the real case is much complicated, so can not using cte to make it work as a model)
Anyone help? SOS.
Thanks,
Alex

Alex - you can take a look at hooks and operations. link