Amazon Cloud Object Storage

Use this connection to import and export data from Amazon web service cloud object storage.

In This Topic

Set up a new connection
Create a table with data from a connection
Export a file

Set up a new connection

Complete the following steps to set up a connection in Minitab Connect.

From the Home screen, select the Add button under Tables.
In Datasets, enter AWS S3 and select the connector from the results. Give the connection a Name.
Enter the Access Key ID, and Secret Access Key that you use to log into your account.
From Region, select the region that contains your S3 bucket. Each AWS region has its own unique endpoint. The S3 endpoint includes the region code as part of the URL. Usually the default region works best, but if you manually sign requests, ensure that the region you specify in your request matches the region that contains the bucket.
From Signature Version, select either version 2 or version 4.
Select Save.

After you save the connection, Connect displays options to import data into a new table. Start at step 4 of the following section for more information on importing data to create a table.

Create a table with data from a connection

Complete the following steps to import data when you used an Access Key as your authentication type.

From the Home screen, select the Add button under Tables.
In Datasets, enter AWS S3 and select the connector from the results.
Under Connection, select the connection that you previously set up. If you have not previously set up a connection, select New Connection and follow the steps in the previous section.
On the left panel, enter a Name that identifies the table and select a Folder to save the table.
In Bucket, enter the name of the S3 bucket that you want to use. In Separator, enter the character separator you want to use to represent directories. Then select Next.
Select the files that you want to import and select Next. If your file is nested in a folder, you have to select the folder and select Next before you can select the file. If your file is nested in multiple folders, you will have to do this step for each folder. Enter text in Key to pull in all files that contain the text.
Under Delete Files, select to delete the file from AWS S3, move it to the Historic folder, or do nothing. If a Historic folder does not exist, Connect creates one.
If you want to pull metadata from skipped rows of a csv file, select one of the yes options from Extract Metadata Info From Header.
Note
You can only use this option with a csv file.

Yes - Extract into "Metadata" column

Pulls the contents of the skipped rows into a single column for every record. Specify the number of rows and columns that you want to skip in Skip Rows and Skip Columns.

Yes - Extract specific values and fields

Pulls data from a specific cell (specified by a column/row value of a cell) and enters it into a field (specified by column/row value of a cell, or by entering in a custom field name) for every record. Specify the number of rows and columns that you want to skip in Skip Rows and Skip Columns. Then specify the cell location using column/row pair. For example, to pull a value from the 3rd column and 2nd row, enter "3,2" in Header Cell Extraction Locations. If you want to pull a field name instead of a value, specify the pair in Header Cell Extraction Fields. You can also specify a custom field name instead of pulling a value from the skipped rows and columns. Separate multiple pairings or custom field names with a "/".
In File Pattern, enter a string to match files for subsequent imports. Enter a percent symbol (%) before and after the string. For example, each day you import a file named "Measurements" that also has the date appended to it. You can enter %Measurements% to import any file name that has the word "Measurements" regardless of the date that is appended to it. If you don't enter a string, subsequent imports look for files that are identical matches to the name of the original import.
Select Save . If you go to the Prep Tool and select Run , Minitab Connect displays the imported data.
Note
If no data appears after you select Run, select Reset Config .

Export a file

Complete the following steps to export data from a Minitab Connect table.

Open the Outputs tab of the Flow Tool .
Select the plus sign beside Export to add a new export.
Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
Enter a Name for the export.
Under View, select a saved view of the table. If you select None, Connect exports all the data from the table. For more information on saved views, go to Example of creating a data view.
Under Delivery, select Connection.
Under Connection, select the AWS S3 connection that you previously set up.