• Home
  • All articles
  • Unity Catalog
  • “Unresolvable Table Valued Function” error when trying to execute CREATE OR REPLACE on a table with read and write permissions

“Unresolvable Table Valued Function” error when trying to execute CREATE OR REPLACE on a table with read and write permissions

Ask the table owner to transfer ownership to you or execute CREATE or REPLACE commands for you.

Written by Rolando García Vargas

Last published at: February 12th, 2025

Problem

You are attempting to execute a function on a table in Unity Catalog when you encounter an Unresolvable Table Valued Function error. You have read and write permissions on the table, but you did not create it. The same function works on tables that you created. 

 

Cause

When you use a CREATE OR REPLACE command, it triggers a DROP TABLE command in the backend. DROP TABLE requires you to have owner permissions for the table. If you do not have owner permissions, the DROP operation fails.

 

Note

In Unity Catalog, having all privileges on a table is not the same as ownership of the table. Ownership includes the ability to grant privileges to others and to drop objects from a table.

 

 

Solution

Request the owner to perform the operation for you, or to grant you ownership. 

For more information, refer to the DROP TABLE (AWS | Azure | GCP) documentation.

For more information on Unity Catalog object ownership, refer to the Manage Unity Catalog object ownership (AWS | Azure | GCP) documentation.