Data Studio
The Data Studio is your central hub for getting data into the platform and managing it. It provides multiple ingestion methods to fit any workflow.
Data Ingestion Methods
| Method | Best For | How |
|---|---|---|
| File Upload | Quick one-time imports, spreadsheets | Drag-and-drop CSV/XLSX files |
| ETL Pipelines | Recurring automated imports | Connect databases, Google Sheets, or APIs on a schedule |
| API Ingestion | Programmatic data push | Send data via HTTP POST to our REST API |
Supported Data Sources
File Upload
- CSV files (comma, semicolon, tab, or pipe delimited)
- XLSX files (Excel — single or multi-sheet, you choose which sheet)
Database & SaaS Connections (Pipelines)
- PostgreSQL, MySQL, SQL Server, MongoDB, BigQuery, Snowflake
- Google Sheets, Microsoft (Excel / SharePoint)
- Shopify, Stripe, HubSpot, Salesforce
- S3/GCS, FTP/SFTP, Kafka, SAP (OData)
- TOTVS Protheus, Notion, Slack
- Inbound API (Push), AI API Client (Pull), MCP Server/Client
See the full list with configuration details on the Connectors page.
Data Processing Features
When you upload or ingest data, the platform automatically:
- Detects column types — strings, numbers, dates, booleans
- Identifies PII — emails, phone numbers, CPF/CNPJ, credit card numbers
- Suggests transformations — trim whitespace, format currency, convert dates
- Matches existing datasets — if we find a >60% schema match, we offer to merge
What Happens to Your Data
Your File → Analysis → Column Mapping → Ingestion → Iara Data Warehouse
↓
Available for Chat, KPIs,
Dashboards, and Analysis
All data is stored in a secure, managed data warehouse, providing:
- ACID transactions for data consistency
- Schema evolution — add/rename columns without breaking queries
- Time travel — query historical versions of your data
- Efficient storage — compressed columnar format for fast performance