python snowflake udf that accesses data in snowflake table

Question

Let us say that I create a python udf like so:

create or replace function addone(i int)
returns int
language python
runtime_version = '3.8'
handler = 'addone_py'
as
$$
def addone_py(i):
  return i+1
$$;

Can I access data from a table + schema of where this udf is deployed - ideally whilst using a non default python package? Thanks!

Answer 1

Not sure why everyone is asking code example. The question is clear. The answer is no, you cannot access a table from python udf. You would need to implement it as a stored procedure, which comes with another limitation: it cannot be called in a select statement