Connect Snowflake with Impira

This article walks through the process of integrating Impira with your Snowflake warehouse so you can extract unstructured data with Impira and stream it back into Snowflake for further analysis.

To see the Impira x Snowflake integration in action, watch this tutorial video of an example workflow involving invoices and payment data:

How to connect Snowflake with Impira

Step 1: Bring data into Impira from Snowflake

  1. After signing into Impira, go to Upload, and From Snowflake.
  1. Enter your Snowflake account information.
  2. In the field, Target table, enter a name for the new table Impira will automatically create in your Snowflake data warehouse.
  3. Choose Submit.
Note: While you're in the Configure automations page, you can see the activity of this integration by choosing View under Status.

Start extracting data with Impira

Step 1: Create fields

With Impira, you can extract data from unstructured and semi-structured files with just a few clicks.

Learn how to create extraction fields (start at Step 3).

Step 2: Fine-tune your resulting predictions

After Impira returns data predictions, use the Review workflow to ensure all your data predictions are accurate. This retrains your new machine learning models and helps them be more useful for continued use.

After you’ve extracted the fields you need and your dataset is fully confident and accurate, you can now go back to Snowflake to query this table and query it against existing datasets already within your warehouse.

Learn more about Snowflake at

© 2023 Impira Inc. All rights reserved. This site is built with Motif.