¶ JSON/CSV Sample Upload
¶ Best For
- Existing JSON data
- API responses
- Quick prototyping
- File-based sources
¶ Process
-
Select "Upload Sample" in schema method
-
Upload JSON File:
{ "customer_id": "550e8400-e29b-41d4-a716-446655440000", "first_name": "John", "last_name": "Doe", "email": "john.doe@example.com", "phone": "+1-555-0123", "created_at": "2025-01-25T14:30:00Z", "lifetime_value": 1299.99, "is_active": true } -
Review Detected Schema:
Field Detected: - customer_id: String (detected as string, can change to UUID) - first_name: String - last_name: String - email: String - phone: String - created_at: Timestamp - lifetime_value: Decimal - is_active: Boolean -
Adjust Types:
- Change
customer_idfrom String to UUID - Set max length for strings
- Mark required fields
- Change
-
Confirm Schema
¶ CSV Sample (Alternative)
customer_id,first_name,last_name,email,lifetime_value
550e8400-e29b-41d4-a716-446655440000,John,Doe,john@example.com,1299.99
¶ Advantages
- Fast schema creation
- Auto-detect data types
- Works with existing files
¶ Disadvantages
- Requires sample data
- May need type adjustments
- Limited relationship detection
¶ Next Steps
- Review Product Schema for field definitions
- Continue with Data Product Creation
- Explore Database Connectors for real-time sync