Skip to main content

Bring Your Data

Dremio enables you to connect to, load, and prepare data from a wide variety of sources to enable unified data access. Whether your data resides in catalogs, object storage, or databases, Dremio provides the tools you need to bring your data into the lakehouse and prepare it for analytics.

Load Data into Tables​

Load data from CSV, JSON, or Parquet files into Apache Iceberg tables for faster, more efficient queries. Dremio supports several methods for loading data:

  • Copy Data Into Tables – Run the COPY INTO command to execute a one-time data load from files into existing Iceberg tables.
  • Autoingest Data – Set up pipe that keep your tables up to date by automatically loading new files into Iceberg tables as they arrive in Amazon S3.
  • Upload Local Files – Upload local files to create Iceberg tables in an Open Catalog for experimentation.

Connect to Your Data​

Connect Dremio to your existing data sources to query data in place without moving it. Dremio supports a wide range of data sources including catalogs, object storage, and databases.

Prepare Your Data​

Transform and enhance your data to make it ready for analytics. Dremio provides tools for data preparation including:

  • Views – Create virtual tables based on SQL queries to transform, join, and aggregate data without moving or duplicating it.
  • Data Transformations – Apply column aliasing, type casting, data cleansing, and create derived columns.
  • AI Functions – Use AI-powered functions to enhance and analyze your data.