Resolving "Share Does Not Exist or Not Authorized" Error in Snowflake

If you encounter an error stating "Share <share_name> does not exist or not authorized" when setting up a database from a Monte Carlo datashare in Snowflake, follow these steps to troubleshoot and resolve the issue:

1. Verify Share Request: Ensure that the datashare request was submitted to Monte Carlo and that you received confirmation of its activation.

2. Account Admin Role: Confirm that the user attempting to access the share is an Account Admin in Snowflake, as other roles may not have visibility of the share.

3. Run Diagnostic Queries: Execute the following queries in Snowflake to gather necessary information and confirm the share name is correct. Share names in Snowflake are case-sensitive and should match exactly, including any potential whitespace.

select CURRENT_ACCOUNT() as account, CURRENT_REGION() as region, CURRENT_ACCOUNT_NAME() as account_name;
show shares;
desc share <provider_account>.<share_name>;

4. Case Sensitivity: Be aware that if QUOTED_IDENTIFIERS_IGNORE_CASE is set to TRUE, Snowflake will treat all alphabetical characters in identifiers as uppercase, which can cause issues if the share name contains lowercase characters.

5. Verify Share Name Format: The correct format for a Snowflake share name provided by MC should resemble the following pattern: 

<owner_account>.<name> 

For example:

JKMKTPS.MC_<AWS_Region>."Monte Carlo <AWS Region>"

If you have followed these steps and the issue persists, please reach out to your Monte Carlo representative or [e-mail] for further assistance. Provide all relevant information and screenshots to expedite the resolution process. For example, include a screenshot of what you see on the 'Shares' -> 'Inbound' page in Snowflake, or detailed steps/screenshots that reproduce the error when attempting to create the database from the share.