Snowflake Connection Configuration - Revision history

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-26T23:56:37Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 23:56, 26 February 2026
Line 117:		Line 117:
	# Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.		# Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	# Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.		# Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.
	# Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege.		# Make sure the Snowflake user for QPR ProcessAnalyzer or the Native App has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege.

	The read privilege for the ''QPR'' stage can be given to the user as follows:		The read privilege for the ''QPR'' stage can be given to the user as follows:

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-26T23:55:49Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 23:55, 26 February 2026
Line 115:		Line 115:
	== Enable auto-create BPMN diagrams ==		== Enable auto-create BPMN diagrams ==
	To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:		To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:
	* Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.		# Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.		# Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege. The read privilege for the ''QPR'' stage can be given to the user as follows:		# Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege.

			The read privilege for the ''QPR'' stage can be given to the user as follows:
	<pre>		<pre>
	GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;		GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-26T23:55:33Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 23:55, 26 February 2026
Line 117:		Line 117:
	* Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.		* Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.		* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege. The read privilege ~~can be given to~~ the ''QPR'' stage as follows:		* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege. The read privilege for the ''QPR'' stage can be given to the user as follows:
	<pre>		<pre>
	GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;		GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;
	</pre>		</pre>

			For the Native App, the read privilege for the ''QPR'' stage will be given to the application as follows:
			<pre>
			GRANT READ ON STAGE <database>.<schema>.QPR TO APPLICATION QPR_PROCESSANALYZER;
			</pre>

	Note that the above configured stages need to exist in all schemas containing eventlog data for the QPR ProcessAnalyzer models (events and cases).		Note that the above configured stages need to exist in all schemas containing eventlog data for the QPR ProcessAnalyzer models (events and cases).

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-16T11:26:10Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 11:26, 16 February 2026
Line 115:		Line 115:
	== Enable auto-create BPMN diagrams ==		== Enable auto-create BPMN diagrams ==
	To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:		To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:
	* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.		* Create a ''Snowflake Managed'' stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.		* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege. The read privilege can be given to the ''QPR'' stage as follows:		* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege. The read privilege can be given to the ''QPR'' stage as follows:

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-13T10:26:44Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 10:26, 13 February 2026
Line 121:		Line 121:
	GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;		GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;
	</pre>		</pre>
	Note that the above configured ~~stage needs~~ to exist in all schemas containing eventlog data for the QPR ProcessAnalyzer models (events and cases).		Note that the above configured stages need to exist in all schemas containing eventlog data for the QPR ProcessAnalyzer models (events and cases).

	==Datatable key for events datatable==		==Datatable key for events datatable==

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-13T10:26:29Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 10:26, 13 February 2026
Line 121:		Line 121:
	GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;		GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;
	</pre>		</pre>
	Note that the above configured stage ~~need~~ to exist in all schemas containing eventlog data for the QPR ProcessAnalyzer models (events and cases).		Note that the above configured stage needs to exist in all schemas containing eventlog data for the QPR ProcessAnalyzer models (events and cases).

	==Datatable key for events datatable==		==Datatable key for events datatable==

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-13T10:25:32Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 10:25, 13 February 2026
Line 117:		Line 117:
	* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.		* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.		* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows:		* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage that gives the read privilege. The read privilege can be given to the ''QPR'' stage as follows:
	<pre>		<pre>
	GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;		GRANT READ ON STAGE <database>.<schema>.QPR TO ROLE <role>;

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-13T10:23:51Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 10:23, 13 February 2026
Line 116:		Line 116:
	To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:		To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:
	* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.		* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files ~~are available on request~~ from customercare@qpr.com.		* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files can be requested from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows:		* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows:
	<pre>		<pre>

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-13T10:23:04Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 10:23, 13 February 2026
Line 115:		Line 115:
	== Enable auto-create BPMN diagrams ==		== Enable auto-create BPMN diagrams ==
	To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:		To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:
	* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled~~, and for~~ the '''Encryption''' select the '''Client-side encryption'''.		* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled. In the '''Encryption''' section, select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files are available on request from customercare@qpr.com.		* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files are available on request from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows:		* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows:

Ollvihe: /* Enable auto-create BPMN diagrams */

2026-02-13T10:22:30Z

Enable auto-create BPMN diagrams

← Older revision		Revision as of 10:22, 13 February 2026
Line 115:		Line 115:
	== Enable auto-create BPMN diagrams ==		== Enable auto-create BPMN diagrams ==
	To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:		To use the [[QPR_ProcessAnalyzer_BPMN_Editor#Auto-creating_BPMN_Diagram_from_Eventlog\|Auto-create diagram]] feature in the BPMN diagram editor, the following configurations are needed in the Snowflake account:
	* Create a stage '''QPR''' to the schema(s) where eventlog data is located. In the stage settings, the '''Directory table''' needs to be enabled, and for the '''Encryption''' select the '''Client-side encryption'''.		* Create a stage named '''QPR''' to the schema(s) where the tables for the eventlog data are located. In the stage settings, the '''Directory table''' needs to be enabled, and for the '''Encryption''' select the '''Client-side encryption'''.
	* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files are available on request from customercare@qpr.com.		* Upload the '''graphviz.whl''' and '''pm4py.whl''' files to the stage. For [[QPR_ProcessAnalyzer_Native_App_in_Snowflake\|Snowflake native app]] and on-premise connected app installations, these files are available on request from customercare@qpr.com.
	* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows:		* Make sure the Snowflake user for QPR ProcessAnalyzer has at least the read privilege to the stage. The user can also be the owner of the stage. The read privilege can be given to the ''QPR'' stage as follows: