Skip to main content

Flourish Software Snowflake Marketplace Data Listing

Access Flourish's data warehouse using a private listing on Snowflake's Marketplace. Combine this data with other proprietary data for custom analytics.

Admin CG
Updated by Admin CG
This feature is in private preview. Please contact us to discuss setting up a private data listing for your account.

Flourish's Cannabis Analytics Snowflake Listing

First, search the Snowflake Marketplace for "Flourish Software." You should see the Flourish listing available. Each listing is specific to a company (or set of deployed Flourish companies) and privately shared per account.

Click "Get" on the listing to add the listing to your account. You can specify a database name and role access. Once added, you will see your database in your Catalog. Once added, you can click "Open" to open a worksheet and start exploring the data.

Using the Flourish EDW Data Listing

Here are some best practices and tips for using the data.

Access Control

You can grant access to specific roles with "Getting" the data in the User Interface. 

-- Option A: Grant to existing role 
          GRANT IMPORTED PRIVILEGES ON DATABASE FLOURISH_SOFTWARE TO ROLE SYSADMIN;
          
          -- Option B: Create dedicated role 
          CREATE ROLE FLOURISH_ANALYST; 
          GRANT IMPORTED PRIVILEGES ON DATABASE FLOURISH_SOFTWARE TO ROLE FLOURISH_ANALYST; 
          GRANT ROLE FLOURISH_ANALYST TO USER username@emaildomain.com;
Computing

Create a dedicated warehouse to use for analytics to monitor and control costs.

Data Structure

The data is modeled with dimension and fact tables.

  • SV_DIM_ is the prefix for dimensions
  • SV_FACT_ is the prefix for facts
Troubleshooting

Issue: Can't find the listing

→ Check with the Flourish team to ensure the listing is published to your account

Issue: "No data visible in tables" → Have the Flourish team verify that your COMPANY_ID is correctly mapped → Contact us to verify access control configuration

Issue: "Permission denied" → Ensure IMPORTED PRIVILEGES granted to your role → Verify role has access to created database

How did we do?

NewYork Microbusiness Tax Filing SOP

Contact