Help center      Reports & Analytics  
BI Integrations

BI Integrations

Updated May 29, 2023

Process Street uses Snowflake to give you access to your Process Street data in a format suitable for use with BI tools like Microsoft PowerBI, Tableau, and others.

Snowflake is a cloud-based database that allows businesses to store, manage, and analyze data in a secure and efficient manner.  With its advanced data-sharing capabilities, Snowflake enables organizations to easily share and collaborate on data with partners and customers.

Note: This add-on is only available in the Enterprise plan. Please reach out to your Customer Success Manager or Account Executive if you’re interested in this feature.

Benefits of accessing your data in Snowflake

Since Snowflake is a data warehousing platform, accessing your data there comes with numerous benefits.

Ease of Use

A BI solution is a simple and easy way to share data between organizations. Once the data-sharing relationship is established, the data can be accessed in a few clicks, without the need to write complex API code or configure data ingestion pipelines.

Quicker Access

Data sharing in a BI solution provides quick access to the shared data. This enables you to work with the latest data available, without having to worry about data latency or delays associated with API data ingestion.

Reduced Overhead

A BI solution eliminates the need for you to maintain and manage data ingestion pipelines or to set up and maintain API authentication and access control mechanisms. This reduces overhead and frees up time and resources to focus on other business priorities.

Scalability

As your data needs grow, a BI solution can easily scale to meet your requirements, providing an efficient and cost-effective solution.

You can go through Snowflake’s documentation on data sharing here.

Tables and Columns available in Snowflake

You can request data pertaining to a lot of aspects as shown below.

  • Approvals
  • Assignments
  • Form field values
  • Form fields
  • Task templates
  • Tasks
  • Workflows (Templates)
  • Workflow Runs (Checklists)
  • Users

Frequently Asked Questions (FAQ)

How can I get access to my data in Snowflake?

We offer the creation of a Reader account. When you add the BI add-on your Enterprise plan, you get access to a private Snowflake Reader account. You’re given a URL, username, and password that you can use to access your private Snowflake database. You can then connect this account to any preferred BI tools for dashboard creation and data analysis.

How do I keep my data up-to-date in Snowflake?

Once we set you up, your data syncs twice a day at 05:00 AM and 05:00 PM UTC. You can start building charts with it right away.

How can I format my data in Snowflake?

You can format it in any way you wish using the SQL-compatible query language provided by Snowflake.

Do I need to integrate with the Process Street API to get my data?

No, you don’t need to connect to our API. You directly integrate your tool with a Snowflake Reader account to access the data (nearly all BI tools have this ability).

How can I get additional information in my data?

We have the ability to offer additional pieces of data, and offer it in different formats, for an additional price. Please reach out to your account manager or our support team for details.

Discover Process Street

Use Process Street to make your team processes fun, fast and faultless. We'll help you transform your team's static checklists into powerful interactive workflows!

Learn more about Process Street

YouTube videos
Deep dive into Process Street with our YouTube video series.
Join a webinar
Effectively record, replicate, and replace your workflow!
See latest releases
Catch up on the latest releases and enhancements.
Join the community
Share with others about how you are using the app day to day.

Take control of your workflows today.