Snowflake

This KB article is part of SYNCHUB's data-extraction knowledge base for Projectworks

Configuring SyncHub to sync your data to Snowflake requires that you configure the appropriate _reader_ and _writer_ roles within your Snowflake instance. ## Troubleshooting ### No active warehouse selected in the current session There are two things required to address this issue: #### Set a default warehouse to your user As part of the setup process, we recommend that you create new _Users_ in Snowflake, specifically for SyncHub to use for reading & writing. These users must have a default warehouse set within Snowflake: ![](https://api.synchub.io/Media/RenderFile?&documentGuid=56c871f6-fd30-477e-a9d2-28a79e348e64&clientID=4&) #### Grant access to the warehouse to your role When you set up the role above, make sure that you also grant access to the warehouse using the following statement (where `COMPUTE_WH` is the name of your warehouse, and `SYNCHUB_READER` is the name of your role): `GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE SYNCHUB_READER;`