Use this connection to communicate between a Snowflake Server and Minitab Connect.
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 Snowflake and select the connector from the results.
- Enter a Name that identifies the connection.
- Enter a Snowflake Account Name, Username and Password for the connection. Then select Next.
- Select the Database and the Warehouse from which you want to pull data. Then select Next.
- Select a database Schema. Then select Next.
- Select the Stage. If you select an external stage, enter your AWS Access Key ID and AWS Secret Access Key.
- From Region, select the region that contains your S3 bucket. From Signature Version, select either version 2 or version 4.
- Then 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 from Snowflake and create a new table in Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Snowflake 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.
- Under Skip to SQL, select Yes to skip the import options and enter the SQL statement manually. Select No to use the Minitab Connect options to create the SQL statement.
- Select the Table and Stage that contain the data that you want to import. Then select Next.
- Select the table Fields, that you want to pull.
- Select Add Filter and select the field you
want to filter. Next, define the filter. Select an expression and a value.
For example, suppose you want a list of the restaurants that begin with the
letter "C". Use the expression, Facility Type, Begins
With, C. Select the
button on the last
selection box to open the SQL dialog box for more complicated filters. - Select Next. Connect displays the SQL statement in Select
Statement. 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
.
When you save the import, Connect creates a flow with the settings that you selected. For more
information on how to schedule a flow and add more data processes to clean data, go
to Overview of the Flow Tool
.
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 connection that you previously set up.
- The File Type must be TAB.
You can a 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.
