Khaja_Zaffer
Esteemed Contributor

Hello @rachelh 

Good day!!

serverless compute enforces stricter rules: serverless can't bypass UC for external storage and defaults to an insufficient privilege check under the hood.
 
The key missing permission is the CREATE TABLE privilege on the schema where you are trying to create the table, along with the correct permissions on the external location. More specifically, the service principal needs to have: CREATE TABLE privilege on the target schema. USAGE privilege on the catalog and schema.