Hello All, I am trying to create pipeline for target

snowflake

and was following the docs provided. While running the pipeline get the following error. These are the commands I ran and do see the file format created. Just checking if I am missing anything. If this was discussed earlier, link to the conversation would be helpful https://github.com/transferwise/pipelinewise-target-snowflake Commands ran in snowflake

-- {database}.{schema}.{file_format}
CREATE or replace FILE FORMAT DEV.dev_meltano.meltano TYPE = 'CSV' ESCAPE='\\' FIELD_OPTIONALLY_ENCLOSED_BY='"';

GRANT USAGE ON FILE FORMAT   DEV.dev_meltano.meltano TO ROLE SYSADMIN

Error Message

I see you're granting usage to sysadmin, but are you also granting usage to whatever role you set up in .env or elsewhere?

Hi @edgar_ramirez_mondragon thanks for responding. I granted usage on

stage

which I created along with the

file format

. Am I misisng something ? I checked the .env and it has all the tokens and secrets in it like TARGET_SNOWFLAKE_AWS_ACCESS_KEY_ID,TARGET_SNOWFLAKE_AWS_SECRET_ACCESS_KEY etc

Oh so it was a misconfigured role?

Yes, the UI and cli had 2 different roles. Once I changed the UI entry correctly, it worked