Use this connection to import and export data from Azure® Blob storage.
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 Azure Blob Storage and select the connector from the results. Give the connection a Name.
- From Authentication Type, select whether you want to connect with a Shared Access Signature (SAS) or an Access Key. Then select Next.
-
Enter the URL of the Azure Blob storage account and either the SAS token or access key that you use to log into Azure Blobs. The SAS token is usually directly after the container name and starts with ?sp=.
- 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 Azure Blob Storage and select the connector from the results.
- Under Connection, select an Azure Blob Storage 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.
- From Containers, select the Azure Blob container that you want to use. Connect displays all containers that the authenticated credentials can access.
- From Import Type, select the how you want to import the data.
- If you select Select from a list and select Next, Connect creates a list of blobs that you can select to import.
- If you select All Files from Container and select Next, you can enter text in Pattern. Connect imports all files that match the pattern within the container. You can use the % symbol as a wildcard. If you leave this field blank, Connect imports all blobs within the container.
- 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 Azure Blob Storate connection that you previously set up.
You can specify the file type and file name along with other options. Select
Save to add the export to the list of exports in the Outputs tab. Select
Run
to run the export.
