How to create a new Named Right so users can interact with data via Snowflake External Account?

[waynea40432451]

Hi,

Is it possible to create a new Named Right so users can interact with data via Snowflake External Account in workflows?

Testing shows that only possible via Admin access, and we need to separate out for standard users to run BAU queries via the external account for Snowflake.

Thanks,

Wayne

[Amine_Abedour · Accepted solution]

Hello @waynea40432451 

Create a new right by specifying your chosen label.

The Name field must take the following format user:base@server, where :

• user corresponds with the name of the user in the external database.

• base corresponds with the name of the external database.

• server corresponds with the name of the external database server.

Please find more info here.

Br,

[waynea40432451]

Thanks for the response and link through to guide.

I have tried to follow the guide but the 'name' field is limited to 64 characters and I need more than that for full string. Any tips on how to extend this please? I've tried to create an extension to the xktgroup schema but that's not worked.

Thanks,

Wayne

[Amine_Abedour]

Hello @waynea40432451,

Extending the schema worked for me. Did you update the database structure after extending the schema ? Clear cache, disconnect and reconnect ?

Br,