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.

3. Enter your Snowflake account information.
4. In the field, Target table, enter a name for the new table Impira will automatically create in your Snowflake data warehouse.
5. Choose Submit.

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.

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.