Skip to main content

Evaluating Striim for Snowflake

A free trial of Striim for Snowflake is available through Snowflake Partner Connect.

Getting your free trial of Striim for Snowflake

Prerequisites for the free trial:

  • a Snowflake account with access to Partner Connect

  • a Snowflake login with the ACCOUNTADMIN role

For more information, see Snowflake Partner Connect and System-Defined Roles.

To start your free trial:

  1. Log in to Snowflake.

  2. On the right side of the top menu, click Partner Connect.

  3. From the drop-down menu under your user name, select Switch Role > ACCOUNTADMIN.

    The Snowflake toolbar, highlighting the Partner Connect button.

  4. Click Striim > Connect> Activate.

  5. Enter your company name, a domain name (this will be the first part of the URL to the Striim application), and a password, check the checkbox, and click Complete Sign Up.

  6. On the next page, click the Visit link.

  7. Enter the email address associated with your Snowflake account and the password you provided in the "Create an account" dialog.

  8. Enter a name for your Striim service and click Create. You should see something like this:

    The user interface for Striim on Snowflake, open to the Services page.

  9. If your database is behind a firewall, click the shield icon to get the IP address to add to the firewall's allow list. When the status changes from CREATING to RUNNING, click Open Application.

    A close-up of the database status line, highlighting the Open Application button.

Continue with the instructions in Creating an application in Striim for Snowflake.

Creating an application in Striim for Snowflake

Before creating an application, you must create a service as described in Getting your free trial of Striim for Snowflake. After completing those steps, you should be looking at the App Wizard page in Striim:

Icon representations of four ways to move data into Snowflake: from Oracle, MySQL, Microsoft SQL Server, and PostgreSQL.

  1. Click the appropriate Lift and Shift wizard for your source database. This will create an application to copy all data from selected tables in your source database to Snowflake.

  2. Enter a name for your application and click Next.

    The Name and Namespace fields for a new PostreSQL Database to Snowflake application. The name is LiftAndShiftPostgreSQL. The namespace is admin.

  3. Enter the requested configuration details and credentials for the source database, then click Next. If the connection check is successful, click Next. Otherwise, click Back and fix the errors in the configuration.

    The setup wizard at step one, Configure Postgres.

  4. Select the schemas you want to move, then click Next. When validation is complete, click Next again.

    The Postgres setup wizard at step 3. There is a list of schemas to select.

  5. Select the tables to include, or click Select All. If any tables contain data types incompatible with the target database, they will not be selectable. When done selecting tables, click Next.

    The Postgres setup wizard at step 5. A list of selectable database tables is shown.

  6. The target properties are set automatically. Do not change them. Click Next.

    The Snowflake target creation screen. There are text fields for Target Name, Input From, Connection URL, Username, Password, and Tables.

  7. When a check appears next to "Starting your data movement," click Next.

    The Creating your Schema page, listing various milestones with green checkmarks.

  8. The Application Progress dialog tracks the progress of your lift and shift operation.

    An image of the running application with a progress bar.

    Above you see the status of the source. Select the target in the left column to see the status in Snowflake.

    An image of the progress bar for the application target.

The imported data is now available in the PC_STRIIM_DB database.

An image of the Snowflake UI with status for the PC_STRIIM_DB database.

To return to Striim for Snowflake, use the login link in the email you received from Striim.

For more information or to request a full version of Striim, click the Drift icon in the lower left corner of the Striim for Snowflake window. If the chatbot can not provide you with the necessary resources, it will connect you with a Striim representative. Alternatively, Contact Striim support.