Skip to main content

Data Studio

Data Studio is the workspace for bringing data into the platform and keeping it reliable over time. It groups file uploads, pipelines, datasets, data quality, and API ingestion into one operational area.

Screenshot of the Data Studio page showing the Pipelines and Upload tabs

What Lives in Data Studio​

AreaWhat it is for
UploadsOne-time CSV and XLSX imports
PipelinesRecurring automated imports from systems and SaaS tools
DatasetsCatalog and review what is already available to the workspace
QualityReview data quality signals and validation issues
Ingestion APISend data programmatically through HTTP

Data Ingestion Methods​

MethodBest ForHow
File UploadQuick one-time imports, spreadsheetsDrag-and-drop CSV/XLSX files
ETL PipelinesRecurring automated importsConnect databases, Google Sheets, or APIs on a schedule
API IngestionProgrammatic data pushSend 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:

  1. Detects column types — strings, numbers, dates, booleans
  2. Identifies PII — emails, phone numbers, CPF/CNPJ, credit card numbers
  3. Suggests transformations — trim whitespace, format currency, convert dates
  4. 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

Next Steps​