SQLite Integration

SQLite is supported as a source only in Edilitics. You connect by uploading a SQLite file directly. Unlike database integrations, no hostname or network credentials are required.

SQLite supports DQ profiling, AI column insights, and AskEdi sessions.

---

Before You Begin

• A .db or .sqlite file exported from your application.
• File size within the limit for your plan (see table below).
• SQLite integrations support full load only. Incremental and CDC are not supported.

File Size Limits by Plan

---

File Security

All uploaded SQLite files go through the following before being stored:

• Virus scan: ClamAV scans the file on upload. Files that fail the scan are rejected.
• Encrypted storage: The file and its inferred schema are AES-encrypted and stored in an isolated, access-controlled storage bucket.
• Schema parsing: Edilitics automatically parses the file to infer accurate data types per column, avoiding generic string-based schemas.

---

Steps to Connect

Step 1: Add the SQLite Integration

1. In Edilitics, go to the Integrate module.
2. Click New Integration.
3. Select SQLite from the integration catalog under Data Stores.

Step 2: Upload Your File

• Click Choose File and select your .db or .sqlite file.
• Edilitics validates the file size against your plan limit. Files over the limit are rejected before upload.

Step 3: Configure the Integration

• Enter an Integration Name.
• Add an optional description.
• Configure AI Column Insights if required. See AI Column Insights.

Step 4: Preview and Save

• Click Preview to verify table structure and confirm Edilitics has parsed the schema correctly.
• Click Save to create the integration.

---

Supported Operations

Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.