Upload a file using Tiger Console

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

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 with the Real-time analytics capability.

Note

This feature is currently not supported for Tiger Cloud on Microsoft Azure.

From CSV

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

   
2. Click to browse, or drag the file to import
3. Configure the import

   

   • 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.

From Parquet

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

   
2. Click to browse, or drag the file to import
3. Configure the import

   

   • 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.

From a text file

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

   
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.

   
4. Click Upload files

   When the upload is finished, find your data imported to a new or existing table in Explorer.

From S3

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 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.
  • Public anonymous user.

Note

This feature is currently not supported for Tiger Cloud on Microsoft Azure.

From CSV

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

   

   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

   

   • 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.

From Parquet

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

   

   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.
• 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: Use psql, COPY, or pg_restore for large or automated imports.
• Sync from S3: Continuously sync CSV and Parquet from an S3 bucket.
• Sync data from PostgreSQL: Continuously replicate from a PostgreSQL database.
• Live import from a database: Migrate with minimal or no downtime.
• Migrate overview: All import and migration options.