Bytebase for training/workshops #17796
Unanswered
ljckennedy
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
I work for a company in the data integration space. When we run workshops and it's preferable to give the attendees a query tool so they can explore the target databases (e.g. run queries of the datamarts they built). We used ot use the database vendor's tools, but as more and more vendors mandate 2FA this is a problem - people don't want to sign up to mfa for a 1-2 hour workshop.. We have had to stop using Snowflake's web-based tools for this reason. Thus we are looking for a query tool we can use in place and Bytebase seems promising. At the moment we are using DBeaver running in a VM, but we want to get rid of the VM if we can.
Our requirement is:
From my reading and a quick look through the UI, it seems like it might do everything we need, which is great. I am hoping someone with real-world experience could give me feedback on this.
The one challenge I had hit so far, is it seems I have to (at least for snowflake) provide a lot of privileges so it can work our what databases are present. I'd prefer if it's possible to just tell it the database, but even if I restrict 'sync databases' to one database, it complains about permissions (e.g. "\n\t\tSELECT\n\t\t\tGRANTEE_NAME,\n\t\t\tROLE\n\t\tFROM SNOWFLAKE.ACCOUNT_USAGE.GRANTS_TO_USERS\n\t": 002003 (02000): SQL compilation error:
Schema 'SNOWFLAKE.ACCOUNT_USAGE' does not exist or not authorized.)
Appreciate the feedback!
Thanks.
Beta Was this translation helpful? Give feedback.
All reactions