Skip to main content
Version: 3.2

DataCloud File Loader API

Overview

This service allows an API consumer to stage and load a file directly into a target table.

  • Allows files up to 1GB
  • Autodetects field and record separators (can be overridden)
  • Autodetects most primitive data types
  • A single date format can be applied to coerce date fields
  • Autodetects common compression formats (zip, tar, gzip, tar.gz, 7z)
  • Staged files can be reloaded without uploading a second time, if the initial load fails
  • Staged files are accessible for up to 7 days (archived for up to 30)

Step 1: Set an API Password

If you have not already done so, you must set a password to enable API access. See Setting Your Password.

Step 2: Locate Your Warehouse Details

  1. Login to Actian Data Platform at https://avalanche.actiandatacloud.com.

  2. Select the Warehouses tab.

  3. Start the desired warehouse if it is not already started:

  4. Select the warehouse:

  5. Note the values of the Storage, Region, and Warehouse ID for the warehouse:

Step 3: Access the File Loader API Doc

Go to the file loader API page for your warehouse region:

CloudRegionFunctional File Loader API Page
AWSUS - Ohiohttps://fileloader.us-east-2.aws.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
AWSEU - Frankfurthttps://fileloader.eu-central-1.aws.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
AzureUS - Virginiahttps://fileloader.eastus2.azure.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
AzureEU - Frankfurthttps://fileloader.germanywestcentral.azure.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
AzureEU - Irelandhttps://fileloader.northeurope.azure.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
GCPUS - South Carolinahttps://fileloader-av-gc-prod-2.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
GCPUK - Londonhttps://fileloader-avprddp-190.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/
GCPEU - Belgiumhttps://fileloader-avprddp-200.avprod.actiandatacloud.com/apidocs/swagger-ui/index.html#/

Step 4: Authorize Your Browser

Notes
  • Tokens are good for up to 10 hrs.
  • You will need to authorize different regions separately.
  1. Click Authorize:

  2. In the Available authorizations dialog, do the following:

    1. Enter your username and password from Step 1 above.

    2. If your file has a header row, select Authorization header in the Client credentials location dropdown. Otherwise, select Request body.

    3. Click Authorize:

Step 5: Autoload

  1. In the warehouse field, enter your warehouse ID from Step 2.

  2. If your file has a header row, select true in the header dropdown.

  3. The remaining fields are optional. You can ignore these unless you have more advanced needs, such as specific date formats.

  4. Click Browse and select the file to load from your computer.

  5. Click Execute.

  6. With a successful post, a response such as the following is returned:

Preview Your Data

To preview the table created in the autoload, do the following:

  1. On the Warehouses page, click Query Editor:

  2. Click the table name. The query editor and table schema are displayed. Click Preview Table to run the query:

  3. The query results are displayed: