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
- After signing into Impira, go to Upload, and From Snowflake.
- Enter your Snowflake account information.
- In the field, Target table, enter a name for the new table Impira will automatically create in your Snowflake data warehouse.
- 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.