error while running dbdemos.install about dbdemos HOT 7 CLOSED

thanks I'll have a look

from dbdemos.

@QuentinAmbard do you have an update?

from dbdemos.

did you check the actual SQL error following the link you have in the message?
I'd say that your workspace isn't properly setup with UC (permission issue with the cloud storage?)

from dbdemos.

I don't see any permission issue, create schema was successful, CREATE TABLE has failed. I do have the right permissions. this catalog is UC enabled. do you think this is related to the way Managed Storage is setup? We use External Storage for other UC tabled tables

--param query - the import needs the query to be run first even empty.
CREATE SCHEMA IF NOT EXISTS dev_bronze.billing_forecast;
CREATE TABLE IF NOT EXISTS dev_bronze.billing_forecast.billing_forecast (sku STRING, workspace_id STRING);

PERMISSION_DENIED: Access denied. Cause: AccessDeniedException error from cloud storage provider. exceptionTraceId=b28e2f64-b232-49ef-9908-f92e277e1b39

from dbdemos.

you have a permission issue for the dev_bronze catalog from what you shared:
PERMISSION_DENIED: Access denied. Cause: AccessDeniedException error from cloud storage provider. exceptionTraceId=b28e2f64-b232-49ef-9908-f92e277e1b39

It's usually the managed identity not properly set to the storage, or something similar

from dbdemos.

the issue has been resolved! I am able figure it out ! Addition of LOCATION to the create table seems to have worked!

from dbdemos.

closing

from dbdemos.