Open
Description
Provide the Bytebase version you are using
3.5.x
Describe the bug
After onboarding a Snowflake instance and granting permissions recommended in Bytebase UI, syncing the database gives the following error:

/bytebase.v1.InstanceService/SyncInstance UNKNOWN: failed to sync instance: snowflake: failed to execute query "\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.
The backend server may be unavailable
If the same user is used to repeat this query in Snowflake, we are able to confirm that SNOWFLAKE.ACCOUNT_USAGE
does exist and the user has appropriate permission to execute this query.
Steps to reproduce
- Onboard a Snowflake instance via Bytebase UI
- Create a database user and grant granular permissions based on the instructions in the Snowflake instance UI
- From the instances view (
/instances
), check the previously onboarded Snowflake instance - Select Sync instance > Sync all databases
Expected behavior
Databases and schema should be able to be synced from Snowflake databases without error
Provide the database you are using
Snowflake
Additional context
No response
Metadata
Metadata
Assignees
Labels
No labels