Connectors

Connect to various data sources ..

Pentaho Data Quality

PDQ Connectors

x

x

Snowflake

Snowflake is a cloud-based data warehousing and analytics platform that separates compute from storage, allowing for scalable and flexible data processing. Snowflake supports structured and semi-structured data, enables data sharing across organizations, and provides features for data lakes, data engineering, and machine learning.

Before you define the Snowflake connection, ensure the prerequisite steps have been completed.

For further information:

1. Click: + icon in the top right-hand corner of the UI.

2. Select Snowflake from the connector list.

Snowflake Connector

1. Enter the following details to connect to your database.

Field	Setting
Connection name	The connection name has to be the same as defined in PDC.
Description
Account	Your Snowflake account
Warehouse
Database
Authentication Type	Username and Password
User
Password

1. Validate the connection details.

2. Click: 'Connect' and select the required Table and Queries - the following screenshot dsiplays the 'Synthea' tables.

Connection to 'Synthea'

x

x

MSSQL

Oracle