sfquickstarts icon indicating copy to clipboard operation
sfquickstarts copied to clipboard

Missing grants for the demo_dbt database

Open sanyamgo opened this issue 4 years ago • 4 comments

Missing grants for the demo_dbt database, dbt seed command throws below error:

Insufficient privileges to operate on database DEMO_DBT

sanyamgo avatar Dec 13 '21 22:12 sanyamgo

@amychen1776

jdanielmyers avatar Dec 14 '21 03:12 jdanielmyers

Thanks @jdanielmyers for tagging me ! @sanyamgo Could you let me know if you used the Partner connect pathway to setup your dbt cloud account? That database name suggests to me that you might have not since the partner connect created database and roles have a pc_ prefix.

amychen1776 avatar Dec 22 '21 14:12 amychen1776

Hi,

I did not set up the Db cloud account. Article says to install dbt on Docker and dbt cloud is not required to build this POC.

https://quickstarts.snowflake.com/guide/data_engineering_with_apache_airflow/index.html?index=..%2F..index#0

Thanks, Sanyam

On Wed, Dec 22, 2021 at 9:07 AM Amy Chen @.***> wrote:

Thanks @jdanielmyers https://github.com/jdanielmyers for tagging me ! @sanyamgo https://github.com/sanyamgo Could you let me know if you used the Partner connect pathway to setup your dbt cloud account? That database name suggests to me that you might have not since the partner connect created database and roles have a pc_ prefix.

— Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/sfquickstarts/issues/189#issuecomment-999602798, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWFAGBNW2RHIDK3MODCCMGTUSHLQ3ANCNFSM5J7JQLDQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you were mentioned.Message ID: @.***>

sanyamgo avatar Dec 22 '21 15:12 sanyamgo

@sanyamgo thank you for the clarification! This was not an workshop created by dbt labs so I wasn't aware of it.

amychen1776 avatar Dec 22 '21 16:12 amychen1776