How to import data from Snowflake
In order to import data into InfoSum from Snowflake, please be aware that interaction with both platforms will be required.
Today, Snowflake offers two InfoSum-compatible options for cloud storage: either Google Cloud Storage (“GCS”) or S3 bucket. Once the data is exported to cloud storage, use InfoSum's file management process to connect the bucket to your Cloud Vault and normalize and publish your data.
As soon as the onboarding process is finished, you are ready to start making the most of InfoSum’s data collaboration capabilities.
In Snowflake
1. Configure your Cloud Storage Integration in Snowflake to access Amazon S3 or Google Cloud Storage
To create your cloud storage, please follow Snowflake's documentation for S3 or GCS documentation.
2. Define the data you want to export from Snowflake
If you have any questions or to validate the process, please contact Snowflake support. Click here for more information about how to format your data.
3. Push the final dataset to the S3 or GCS bucket
You need to set up the appropriate connector to send your data from Snowflake to InfoSum. Contact Snowflake support to confirm you have set up the connection correctly.
You can choose to export a CSV file from Snowflake to an S3 or GCS bucket. InfoSum offers connectors for both S3 and GCS buckets. You can also choose your preferred authentication method based on your preference.
Once this is complete, you will then be able to create an Import Connector Config to easily upload the file into InfoSum.
In InfoSum
4. Create a Cloud Vault
Follow these instructions to create a Cloud Vault to host your files whilst they go through the normalization process.
5. Create an Import Connector Configuration (ICC)
Create an ICC to connect your Bucket:
6. Continue importing and normalizing your data
The articles below can help you complete the process of publishing your data to a Bunker