Connecting Your Data
Learn how to import your data to Pecan and export your predictions
25 articles
- 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 Delta Lake tablesConnect compressed, schema-flexible Delta Lake tables on AWS S3 to Pecan for faster, storage-smart analytics.
- AWS S3 Parquet files
- Oracle connector
- Snowflake connectorLearn how to securely connect Pecan to Snowflake using key-pair or username/password authentication methods.
- 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
- Databricks connector