{"id":6760,"date":"2023-04-13T08:00:07","date_gmt":"2023-04-13T08:00:07","guid":{"rendered":"https:\/\/www.process.st\/help\/docs\/bi-integrations\/"},"modified":"2025-04-07T15:24:18","modified_gmt":"2025-04-07T15:24:18","slug":"bi-integrations","status":"publish","type":"ht_kb","link":"https:\/\/www.process.st\/help\/docs\/bi-integrations\/","title":{"rendered":"BI Integrations"},"content":{"rendered":"<p>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.<\/p>\n<p>Snowflake is a cloud-based database that allows businesses to store, manage, and analyze data in a secure and efficient manner.\u00a0 With its advanced data-sharing capabilities, Snowflake enables organizations to easily share and collaborate on data with partners and customers.<\/p>\n<p><strong>Note:<\/strong> This add-on is only available in the <a href=\"https:\/\/www.process.st\/pricing\/\">Enterprise<\/a> plan. Please reach out to your <a href=\"https:\/\/www.process.st\/help\/docs\/support\/\">Customer Success Manager or Account Executive<\/a> if you&#8217;re interested in this feature.<\/p>\n<h2><strong>Benefits of accessing your data in Snowflake<\/strong><\/h2>\n<p>Since Snowflake is a data warehousing platform, accessing your data there comes with numerous benefits.<\/p>\n<h3>Ease of Use<\/h3>\n<p>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.<\/p>\n<h3>Quicker Access<\/h3>\n<p>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.<\/p>\n<h3>Reduced Overhead<\/h3>\n<p>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.<\/p>\n<h3>Scalability<\/h3>\n<p>As your data needs grow, a BI solution can easily scale to meet your requirements, providing an efficient and cost-effective solution.<\/p>\n<p>You can go through <a href=\"https:\/\/docs.snowflake.com\/en\/user-guide\/data-sharing-intro\">Snowflake&#8217;s documentation<\/a> on data sharing here.<\/p>\n<h2><strong>Tables and Columns available in Snowflake<\/strong><\/h2>\n<p>You can request data pertaining to a lot of aspects as shown below. If any of these tables are missing from your data source, please let your Process Street representative know.<\/p>\n<ul>\n<li>Approvals<\/li>\n<li>Assignments<\/li>\n<li>Data sets<\/li>\n<li>Data set rows<\/li>\n<li>Form fields<\/li>\n<li>Form field values<\/li>\n<li>Task templates<\/li>\n<li>Tasks<\/li>\n<li>Tags<\/li>\n<li>Tag memberships (mapping table between a tag and workflow)<\/li>\n<li>Workflows (Templates)<\/li>\n<li>Workflow runs (Checklists)<\/li>\n<li>Users<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-15566\" src=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2024\/02\/snowflake-tables.jpeg\" alt=\"\" width=\"100%\" \/><\/p>\n<h2>Data Sets<\/h2>\n<h3>Data Sets<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-8628\" src=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds1.png\" alt=\"Dat Sets in Snowflake\" width=\"100%\" srcset=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds1.png 928w, https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds1-300x193.png 300w, https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds1-768x493.png 768w\" sizes=\"(max-width: 928px) 100vw, 928px\" \/><\/p>\n<h3>Data Set records<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-8629\" src=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds2.png\" alt=\"Data Set records in Snowflake\" width=\"100%\" srcset=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds2.png 914w, https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds2-300x239.png 300w, https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds2-768x612.png 768w\" sizes=\"(max-width: 914px) 100vw, 914px\" \/><\/p>\n<h3>Due date rule definitions<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-8630\" src=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds3.png\" alt=\"Due date definition in Snowflake\" width=\"100%\" srcset=\"https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds3.png 922w, https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds3-300x204.png 300w, https:\/\/www.process.st\/help\/wp-content\/uploads\/2023\/04\/ds3-768x521.png 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/p>\n<h2><strong>Frequently Asked Questions (FAQ)<\/strong><\/h2>\n<h3>How can I get access to my data in Snowflake?<\/h3>\n<p>We offer the creation of a Reader account. When you add the BI add-on your Enterprise plan, you get access to a private <a class=\"c-link c-link--underline\" href=\"https:\/\/docs.snowflake.com\/en\/user-guide\/data-sharing-intro\" target=\"_blank\" rel=\"noopener noreferrer\" data-stringify-link=\"https:\/\/docs.snowflake.com\/en\/user-guide\/data-sharing-intro\" data-sk=\"tooltip_parent\">Snowflake Reader account<\/a>. You&#8217;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.<\/p>\n<h3>How do I keep my data up-to-date in Snowflake?<\/h3>\n<p>Once we set you up, your data syncs every 2 hours. You can start building charts with it right away.<\/p>\n<h3>How can I format my data in Snowflake?<\/h3>\n<p>You can format it in any way you wish using the SQL-compatible query language provided by Snowflake.<\/p>\n<h3>Do I need to integrate with the Process Street API to get my data?<\/h3>\n<p>No, you don\u2019t 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).<\/p>\n<h3>How can I get additional information in my data?<\/h3>\n<p>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 <a href=\"mailto:support@mail.process-street.com\">support team<\/a> for details.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.\u00a0 With its advanced data-sharing capabilities, Snowflake enables [&hellip;]<\/p>\n","protected":false},"author":14,"template":"","meta":{"_acf_changed":false,"available_plan":"Enterprise","available_product":"Reports","footnotes":""},"ht_kb_category":[200],"ht_kb_tag":[489,490],"class_list":["post-6760","ht_kb","type-ht_kb","status-publish","hentry","ht_kb_category-reports-analytics","ht_kb_tag-bi-reporting","ht_kb_tag-snowflake"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb\/6760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/users\/14"}],"version-history":[{"count":10,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb\/6760\/revisions"}],"predecessor-version":[{"id":8631,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb\/6760\/revisions\/8631"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/media?parent=6760"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb_category?post=6760"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb_tag?post=6760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}