I set up a Pre Aggregation on Source Database Snowflake Howe

Question

I set up a Pre Aggregation on Source Database Snowflake However getting an error stating Insufficient privileges to operate on database ```Performing query 0d3bb4b3 7837 4420 b91e 3334042f2ba1 span 1 Error while querying 0d3bb4b3 7837 4420 b91e 3334042f2ba1 span 1 3702ms processingId 1 queueSize 1 queryKey CREATE TABLE arch council app cube aws billing cost by account AS SELECT n cube aws billing ACCOUNT ALIAS cube aws billing account alias date trunc MONTH CONVERT TIMEZONE UTC cube aws billing BILL DATE timestamp tz timestamp ntz cube aws billing bill date month sum cube aws billing SERVICE COST cube aws billing service cost n FROM n ARCH COUNCIL APP AWS BILLING AS cube aws billing GROUP BY 1 2 refresh key 463123 queuePrefix SQL PRE AGGREGATIONS STANDALONE default timeInQueue 1 preAggregationId cube aws billing cost by account newVersionEntry table name arch council app cube aws billing cost by account structure version ulrf25hc content version bxxvnrki last updated at 1667246128534 naming version 2 preAggregation preAggregationId cube aws billing cost by account timezone UTC timestampFormat YYYY MM DD T HH mm ss SSS Z tableName arch council app cube aws billing cost by account invalidateKeyQueries SELECT FLOOR UNIX TIMESTAMP 3600 as refresh key external true renewalThreshold 120 type rollup external true previewSql SELECT FROM arch council app cube aws billing cost by account LIMIT 1000 preAggregationsSchema arch council app loadSql CREATE TABLE arch council app cube aws billing cost by account AS SELECT n cube aws billing ACCOUNT ALIAS cube aws billing account alias date trunc MONTH CONVERT TIMEZONE UTC cube aws billing BILL DATE timestamp tz timestamp ntz cube aws billing bill date month sum cube aws billing SERVICE COST cube aws billing service cost n FROM n ARCH COUNCIL APP AWS BILLING AS cube aws billing GROUP BY 1 2 sql SELECT n cube aws billing ACCOUNT ALIAS cube aws billing account alias date trunc MONTH CONVERT TIMEZONE UTC cube aws billing BILL DATE timestamp tz timestamp ntz cube aws billing bill date month sum cube aws billing SERVICE COST cube aws billing service cost n FROM n ARCH COUNCIL APP AWS BILLING AS cube aws billing GROUP BY 1 2 uniqueKeyColumns cube aws billing account alias cube aws billing bill date month aggregationsColumns sum cube aws billing service cost dataSource default granularity month preAggregationStartEndQueries select min CONVERT TIMEZONE UTC cube aws billing BILL DATE timestamp tz timestamp ntz from ARCH COUNCIL APP AWS BILLING AS cube aws billing select max CONVERT TIMEZONE UTC cube aws billing BILL DATE timestamp tz timestamp ntz from ARCH COUNCIL APP AWS BILLING AS cube aws billing indexesSql createTableIndexes readOnly false addedToQueueTime 1667246128534 OperationFailedError SQL access control error Insufficient privileges to operate on database GBI OTHERS DATA ENG DB at createError cube node modules snowflake sdk lib errors js 536 15 at Object exports createOperationFailedError cube node modules snowflake sdk lib errors js 315 10 at Object callback cube node modules snowflake sdk lib services sf js 647 28 at cube node modules snowflake sdk lib http base js 111 25 at done cube node modules urllib lib urllib js 589 5 at cube node modules urllib lib urllib js 953 9 at decodeContent cube node modules urllib lib urllib js 740 14 at handleResponseCloseAndEnd cube node modules urllib lib urllib js 924 7 at IncomingMessage lt anonymous gt cube node modules urllib lib urllib js 962 7 at IncomingMessage emit events js 412 35 at IncomingMessage emit domain js 475 12 at endReadableNT internal streams readable js 1333 12 at processTicksAndRejections internal process task queues js 82 21 Error querying db 0d3bb4b3 7837 4420 b91e 3334042f2ba1 span 1 SELECT `cube aws billing account alias` `cube aws billing account alias` sum `cube aws billing service cost` `cube aws billing service cost` FROM arch council app cube aws billing cost by account AS `cube aws billing cost by account` GROUP BY 1 ORDER BY 2 DESC LIMIT 50 params Error SQL access control error Insufficient privileges to operate on database GBI OTHERS DATA ENG DB at QueryQueue parseResult cube node modules cubejs backend query orchestrator src orchestrator QueryQueue js 146 13 at QueryQueue executeInQueue cube node modules cubejs backend query orchestrator src orchestrator QueryQueue js 135 19 at processTicksAndRejections internal process task queues js 95 5 at PreAggregationLoader loadPreAggregationWithKeys cube node modules cubejs backend query orchestrator src orchestrator PreAggregations ts 742 7 at preAggregationPromise cube node modules cubejs backend query orchestrator src orchestrator PreAggregations ts 1946 28 at QueryOrchestrator fetchQuery cube node modules cubejs backend query orchestrator src orchestrator QueryOrchestrator ts 158 59 at OrchestratorApi executeQuery cube node modules cubejs backend server core src core OrchestratorApi ts 85 20 at cube node modules cubejs backend api gateway src gateway ts 1230 21 at async Promise all index 0 at ApiGateway getSqlResponseInternal cube node modules cubejs backend api gateway src gateway ts 1228 31 at cube node modules cubejs backend api gateway src gateway ts 1357 28 at async Promise all index 0 at ApiGateway load cube node modules cubejs backend api gateway src gateway ts 1348 23 at cube node modules cubejs backend api gateway src sql server ts 101 13 Orchestrator error 0d3bb4b3 7837 4420 b91e 3334042f2ba1 span 1 3832ms measures cube aws billing service cost dimensions cube aws billing account alias segments order cube aws billing service cost desc limit 50 securityContext appName NULL protocol postgres apiType sql Error SQL access control error Insufficient privileges to operate on database GBI OTHERS DATA ENG DB 2022 10 31 19 55 32 267 ERROR cubejs native transport transport load strange response success which contains error V1Error error Error SQL access control error nInsufficient privileges to operate on database GBI OTHERS DATA ENG DB Cube SQL Error undefined apiType sql protocol postgres appName NULL Error during processing PostgreSQL message Internal Execution error Internal Error SQL access control error Insufficient privileges to operate on database GBI OTHERS DATA ENG DB ``` However I am able to execute the create table as query with the ```CUBEJS DB USER=gbi others data eng db arch council user``` ```CREATE TABLE arch council app cube aws billing cost by account AS SELECT cube aws billing ACCOUNT ALIAS cube aws billing account alias date trunc MONTH CONVERT TIMEZONE UTC cube aws billing BILL DATE timestamp tz timestamp ntz cube aws billing bill date month sum cube aws billing SERVICE COST cube aws billing service cost FROM ARCH COUNCIL APP AWS BILLING AS cube aws billing GROUP BY 1 2``` What am I missing here

salmon-motherboard-78006 · Answer

you are prob executing them with different roles

salmon-motherboard-78006 · Answer

the role through pulumi is the same role that you are executing through the Console

salmon-motherboard-78006 · Answer

I find it less confusing when I pass a specific Provider when I run a query or create a resource <https www pulumi com registry packages snowflake api docs provider >

fierce-horse-21860 · Answer

I am setting the env variable in the env file ```CUBEJS DB SNOWFLAKE ROLE=```

fierce-horse-21860 · Answer

Sorry I am new to cube and don t understand how Pulumi fits into the picture I am providing all configs through the env file