Databricks Community

saurabh_aher

hi , I am trying to create a databricks sql unity catalog function which will take table_name as input parameter and returns the full table as output. I am getting error, kindly help CREATE OR REPLACE FUNCTION catalog.schema.get_table( table_name STR...

saurabh_aher · 07-30-2025

I have usecase where we requires rows more than 1M. buts recursion is limited to 1M. how to increase this limit in Recursive CTE ?

saurabh_aher

any workaround for this ??

saurabh_aher · 07-31-2025

I have a Databricks SQL table with the following columns:id | name | managerId | rolenameThis table contains hierarchical data for all employees in the organization, where each employee has an associated manager (except for the CEO, whose managerId ...

saurabh_aher · 07-31-2025

Its not working then as well.

saurabh_aher · 07-31-2025

example of that.

saurabh_aher · 07-31-2025

yes I tried that but its giving syntax error when its done.

Databricks Community

User Stats

User Activity

databricks sql create function - input table name as parameter and returns complete table.

RECURSION_ROW_LIMIT - how to increase more than 1M ?

Re: databricks sql create function - input table name as parameter and returns complete table.

Re: RECURSION_ROW_LIMIT - how to increase more than 1M ?

Re: RECURSION_ROW_LIMIT - how to increase more than 1M ?

Re: RECURSION_ROW_LIMIT - how to increase more than 1M ?

Re: RECURSION_ROW_LIMIT - how to increase more than 1M ?