_name appended to the name holding the string representation of the enum (e.g. state → state_name).{Tenant ID}_CORE), which is already filtered to that tenant. The tables therefore do not contain a tenant_id column.There are currently two options to get access to the data. Depending on needs and use-case one of the options is activated by Data Engineering Team.
Wunder will create a Snowflake share, customer will see the shared database in Snowflake UI/Snowpipe in Data Products → Private Sharing.
⚠️ Network Level Security
We are using Network Level Policies to restrict access to Snowflake, with that access method, to have an additional layer of security to protect data of our customers. We would need the public IPs, which you will use to connect to Snowflake. This will typically be something like IPs of the Office, Data Center (where they generate the reports), VPN outbreak, …
There are plenty of tools/drivers available which can connect to Snowflake.
You will receive Tenant ID and Password through Wunder Support or an direct communication channel.
The following is a list of options on how to configure it:
| Option | Value |
|---|---|
| Host | GZNXIDS-WUNDER.snowflakecomputing.com |
| Authentication | Username & Password |
| User | TENANT_{Tenant ID} |
| Password | You will receive that. |
| Role | TENANT_{Tenant ID} |
| Database | PRO_DATA_SHARING |
| Schema | {Tenant ID}_CORE |
| Warehouse | TENANT_{Tenant ID} |