> ## Documentation Index
> Fetch the complete documentation index at: https://docs.corvic.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Extract Tables

> Extract and prepare structured data for further processing and analysis

## Overview

Extract Tables is a feature that processes structured data sources to extract metadata and prepare them for further processing such as data augmentation or text-to-SQL operations in agents. This feature works with any structured data format including parquet files, CSV files, databases, time series data, knowledge graphs, and data warehouses.

## Category

**Structured Data** - This feature is designed to work with structured data sources containing columns, tables, and relational data formats.

## Input

The Extract Tables feature accepts data from the following input sources:

1. **File Upload** - Upload structured files directly from your local system. Supported formats include:

   * **Parquet files**: Columnar storage format optimized for analytics
   * **CSV files**: Comma-separated values and other delimited text files
   * **Any data with columns**: Tabular data formats with defined schemas

   <Tip>
     **Learn more:** [Data Sources](/features/data-sources) - Upload and manage data sources
   </Tip>

2. **Live Data Connectors** - Connect directly to live data sources without duplicating data:

   * **Databases**: Direct connections to relational databases
   * **Data Warehouses**: Snowflake, Databricks, and other data warehouse systems
   * **Time Series Data**: Structured time-based data sources
   * **Knowledge Graphs**: Graph-structured data with relationships

   <Tip>
     **Learn more:** ▶️ [Live Data Connectors Tutorial](/tutorials/live-data-connectors) - Connect directly to live data sources
   </Tip>

<Note>
  The input data source must be marked as "Structured Type" in your data room. The feature works with any data that has columns and a defined schema.
</Note>

## Output

**Corvic Table** - The Extract Tables feature produces a new Corvic Table with extracted metadata to prepare for further processing such as augmentation or text-to-SQL operations in agents. The output includes:

* **Schema Metadata**: Column names, data types, and constraints extracted from the input data
* **Data Quality Metrics**: Statistics and quality indicators for each column
* **Relationship Information**: Foreign keys, relationships, and dependencies between tables
* **Processing Ready Format**: Structured representation optimized for downstream operations

<Info>
  The output Corvic Table provides comprehensive metadata extraction that enables advanced processing operations including data augmentation, text-to-SQL query generation, and agent-based data operations. This metadata serves as the foundation for intelligent data transformations and analysis workflows.
</Info>

## Parameters

| Parameter           | Type     | Required | Description                                                                                                                                                                                                                                                                                                                              |
| ------------------- | -------- | -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `input_data_source` | `string` | Yes      | The structured data source to process. Select a data source from your data room that contains structured data with columns. Can be parquet files, CSV files, database connections, time series data, knowledge graphs, or data warehouse connections (Snowflake, Databricks, etc.). The data source must be marked as "Structured Type". |
| `output_name`       | `string` | No       | Optional custom name for the output Corvic Table. If not provided, a default name will be automatically generated based on the input data source name.                                                                                                                                                                                   |

## Usage Example

To use Extract Tables in a Data App:

1. Add your structured data source to the Data App canvas
2. Click the "+" button next to the data source
3. Select "Extract Tables" from the actions menu
4. Select the input data source (if not already selected)
5. Optionally provide a name for the output Corvic Table
6. Run the Data App to execute the extraction
7. Review the generated Corvic Table containing extracted metadata ready for further processing such as augmentation or text-to-SQL operations

## Related Documentation

<CardGroup cols={2}>
  <Card title="Data Apps" icon="sitemap" href="/features/data-apps">
    Learn how to build workflows using Data Apps.
  </Card>

  <Card title="Corvic Tables" icon="eye" href="/concepts/feature-views">
    Understand how Corvic Tables work with extracted structured data.
  </Card>

  <Card title="Agents" icon="robot" href="/features/agents">
    Use extracted data for text-to-SQL operations in agents.
  </Card>

  <Card title="Data Sources" icon="database" href="/features/data-sources">
    Learn how to upload and manage structured data sources.
  </Card>
</CardGroup>