How do I receive data into my data warehouse?
If you wish to receive cleaned and standardised data from 7bridges into your data warehouse to view the information in your own reporting system you are able to do that.
There are two options:
- Provides us with AWS/GCP/Azure key/IAM role or similar. We will write to your Object Storage on a set cadence. We can do the same directly to your Data Warehouse if you use Snowflake, Databricks, or similar.
- If you wish to query your data on demand we can grant user/role access to a dedicated cluster for your data which you can query as desired.
Both options carry a cost which will need to be discussed with your account executive. The costs for both solutions vary, with option 2 typically being more expensive.
Our recommendations is to go option 1 as this is a standard data exchange methodology, is relatively cost effective and for most use cases real-time querying is not required.