All Collections
Connecting Your Data
Learn how to import your data to Pecan and export your predictions
Creating a data connection
How to import data from your connectionFeeding Pecan your data is a breeze! Select your tables, tailor your settings, opt for a reference column, and click 'Import data' ✨
Data importing configurations and methodsImport only new Rows, the full table, and overwrite - all to ensure accurate, efficient model training with easy method selection.
Deleting Files & Connections in PecanKeep your Pecan environment tidy with our simple guide on removing unnecessary files and connections
What is a reference column, and when do you need one?Pecan optimizes table imports using reference columns to identify new rows, saving you time and resources.
Maintaining Data Integrity in Pecan Amidst Architecture ChangesKeep your model on track by aligning data changes with imported tables to avoid mismatches.
Data partitioning in PecanEfficiently manage large datasets in Pecan with strategic data partitioning, enhancing query performance and prediction speed.
Enhanced Table PreviewsLearn how to use Pecan's Enhanced Table Preview to get a quick, graphical summary and key stats of your imported data.
Pecan connectors information
Learn how to connect PEcan to your Data Warehouse or CRM
AWS S3 Parquet files
Oracle connector
Snowflake connector
Microsoft SQL Server connectorEasily connect to your Microsoft SQL Server with Pecan, so you can create models using your existing data.
Google BigQuery connector
IBM Db2 connectorEasily connect to your IBM Db2 with Pecan, so you can create models using your existing data.
Amazon Redshift connectorEasily connect to your Amazon Redshift data warehouse with Pecan, so you can create models using your existing data.
PostgreSQL connector
MySQL connector
HubSpot Connector
ClickHouse database connectorEasily connect to your ClickHouse Server with Pecan, so you can create models using your existing data.
Create a "Read" Connection To Salesforce
Create a "Write" Connection To SalesforceOptimize your CRM with predictive data—learn to connect, configure, and export Pecan insights directly to Salesforce