below is the stored procedure that we created and it returns table with columns ID, Name
how to Use the result set in snowflake select statement. I tried like below but it did not work

select * from table(test_sp.test_procedure(‘john’))

create or replace Procedure test_sp.test_procedure(name varchar)
returns table(id varchar,name varchar)
language python
packages = ('pandas','snowflake-snowpark-python')
runtime_version=3.8
handler='get_data'
AS
$$
def get_data(session,name):
sql = f'''SELECT
ID,NAME
FROM TEST_SP.TABLE
WHERE NAME = '{name}'; '''
df_sql = session.sql(sql )
return df_sql
$$;