--- title: Upload a file using Tiger Console | Tiger Data Docs description: Upload CSV, Parquet, and text files into your Tiger Cloud service using Tiger Console. Drag and drop from your local machine, or provide a path to the file in S3 --- Early access You can upload files into your service using Tiger Console. This page explains how to upload CSV, Parquet, and text files, from your local machine and from an S3 bucket. - [From a local machine](#tab-panel-654) - [From S3](#tab-panel-655) Tiger Console enables you to drag and drop files to upload from your local machine. ## Prerequisites To follow the steps on this page: - Create a target [Tiger Cloud service](/docs/get-started/quickstart/create-service/index.md) with the Real-time analytics capability. Note This feature is currently not supported for Tiger Cloud on Microsoft Azure. - [From CSV](#tab-panel-649) - [From Parquet](#tab-panel-650) - [From a text file](#tab-panel-651) To upload a CSV file to your service: 1. **Select your service in Console, then click `Actions` > `Import data` > `Upload your files` > `Upload CSV file`** ![Uploading a CSV file in Tiger Console](/docs/_astro/tiger-console-import-csv-file.BkoVQluF_Z2mprl7.webp) 2. **Click to browse, or drag the file to import** 3. **Configure the import** ![Configuring CSV file import settings in Tiger Console](/docs/_astro/tiger-console-configure-csv-file-import.DB2T-5Qu_19CmmD.webp) - Set a delimiter. - Toggle to skip or keep the header. - Select to ingest the data into an existing table or create a new one. - Provide the new or existing table name. - (Optional) For a new table with a time column, toggle the time column to create a hypertable instead of a regular table. 4. **Click `Process CSV file`** When the processing is completed, to find the data your imported, click `Explorer`. To upload a Parquet file to your service: 1. **Select your service in Console, then click `Actions` > `Import data` > `Upload your files` > `Upload Parquet file`** ![Uploading a Parquet file in Tiger Console](/docs/_astro/tiger-console-import-parquet-file.CzBW9bHU_Z18JYsq.webp) 2. **Click to browse, or drag the file to import** 3. **Configure the import** ![Configuring Parquet file import settings in Tiger Console](/docs/_astro/tiger-console-configure-parquet-file-import.BkwGEMxh_288iRb.webp) - Select to ingest the data into an existing table or create a new one. - Provide the new or existing table name. - (Optional) For a new table with a time column, toggle the time column to create a hypertable instead of a regular table. 4. **Click `Process Parquet file`** When the processing is completed, to find the data your imported, click `Explorer`. To upload a TXT or MD file to your service: 1. **Select your service in Console, then click `Actions` > `Import data` > `Upload your files` > `Upload Text file`** ![Uploading a text file in Tiger Console](/docs/_astro/tiger-console-import-txt-file.C-NvIcJx_ZVf6Hr.webp) 2. **Click to browse, or drag and drop the file to import** 3. **Configure the import** Provide a name to create a new table, or select an existing table to add data to. ![Configuring text file import settings in Tiger Console](/docs/_astro/tiger-console-configure-txt-file-import.Dfe1MrvR_Z97qqO.webp) 4. **Click `Upload files`** When the upload is finished, find your data imported to a new or existing table in `Explorer`. Tiger Console enables you to upload CSV and Parquet files, including archives compressed using GZIP and ZIP, by connecting to an S3 bucket. ## Prerequisites To follow the steps on this page: - Create a target [Tiger Cloud service](/docs/get-started/quickstart/create-service/index.md) with the Real-time analytics capability. * Ensure access to a standard Amazon S3 bucket containing your data files. * Configure access credentials for the S3 bucket. The following credentials are supported: - [IAM Role](https://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles_create_for-user.html#roles-creatingrole-user-console). - [Public anonymous user](https://docs.aws.amazon.com/AmazonS3/latest/userguide/example-bucket-policies.html#example-bucket-policies-anonymous-user). Note This feature is currently not supported for Tiger Cloud on Microsoft Azure. - [From CSV](#tab-panel-652) - [From Parquet](#tab-panel-653) To import a CSV file from an S3 bucket: 1. **Select your service in Console, then click `Actions` > `Import data` > `Explore import options` > `Import from S3`** 2. **Select your file in the S3 bucket** ![Importing a CSV file from S3 in Tiger Console](/docs/_astro/import-csv-file-from-s3.CQ0PWk1C_O3uev.webp) 1. Provide your file path. 2. Select `CSV` in the file type dropdown. 3. Select the authentication method: - `IAM role` and provide the role. - `Public`. 4. Click `Continue`. 3. **Configure the import** ![Configuring CSV import from S3 in Tiger Console](/docs/_astro/configure-csv-file-import-from-s3.D4m2Sg7I_ZgO2nL.webp) - Set a delimiter. - Toggle to skip or keep the header. - Select to ingest the data into an existing table or create a new one. - Provide the new or existing table name. - (Optional) For a new table with a time column, toggle the time column to create a hypertable instead of a regular table. 4. **Click `Process CSV file`** When the processing is completed, to find the data your imported, click `Explorer`. To import a Parquet file from an S3 bucket: 1. **Select your service in Console, then click `Actions` > `Import from S3`** 2. **Select your file in the S3 bucket** ![Importing a Parquet file from S3 in Tiger Console](/docs/_astro/tiger-cloud-import-parquet-file-from-s3.CvaiIqH-_n8zt9.webp) 1. Provide your file path. 2. Select `Parquet` in the file type dropdown. 3. Select the authentication method: - `IAM role` and provide the role. - `Public`. 4. Click `Continue`. 3. **Configure the import** - Select `Create a new table for your data` or `Ingest data to an existing table`. - Provide the new or existing table name. - (Optional) For a new table with a time column, toggle the time column to create a hypertable instead of a regular table. 4. **Click `Process Parquet file`** When the processing is completed, to find the data your imported, click `Explorer`. And that is it, you have imported your data to your Tiger Cloud service. ## Troubleshooting - **Upload fails or times out:** Use a smaller file or split the data. For large or automated loads, use [import via terminal](/docs/migrate/import-terminal/index.md). - **Column mapping errors:** Ensure headers match the expected table columns, including case. - **Data type or null errors:** Check that values fit the column types and that NOT NULL columns have no empty values, or adjust null handling in the import settings. - **Encoding issues:** Save the file as UTF-8 to avoid corrupted characters. ## Related - [Upload a file using the terminal](/docs/migrate/import-terminal/index.md): Use `psql`, `COPY`, or `pg_restore` for large or automated imports. - [Sync from S3](/docs/migrate/livesync-for-s3/index.md): Continuously sync CSV and Parquet from an S3 bucket. - [Sync data from PostgreSQL](/docs/migrate/livesync-for-postgresql/index.md): Continuously replicate from a PostgreSQL database. - [Live import from a database](/docs/migrate/live-migration/index.md): Migrate with minimal or no downtime. - [Migrate overview](/docs/migrate/index.md): All import and migration options.