How to create a new Named Right so users can interact with data via Snowflake External Account? | Community
Skip to main content
W
waynea40432451
Level 2
November 21, 2024
Solved

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

  • November 21, 2024
  • 1 reply
  • 1029 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Amine_Abedour

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,

1 reply

Amine_Abedour
Community Advisor
Amine_AbedourCommunity AdvisorAccepted solution
Community Advisor
November 21, 2024

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,

Amine ABEDOUR
    W
    waynea40432451Author
    Level 2
    November 21, 2024

    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
    Community Advisor
    Amine_AbedourCommunity Advisor
    Community Advisor
    November 25, 2024

    Hello @waynea40432451,

     

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

     

    Br,

    Amine ABEDOUR
    Terms & ConditionsAccessibility statement

    Loading footer...