App Modules
...
Data Warehouse
Snowflake
5 min
snowflake is a cloud based data warehousing platform designed to handle large volumes of data and enable efficient data analysis it provides a highly scalable and flexible architecture that allows organizations to store, process, and analyze data from various sources in a centralized repository what can you do with snowflake in custify? you will be able to retrieve people, events, and companies from your snowflake data warehouse you will be able to easily map your source data to custify’s designated data objects, and use these events in the same way as the ones that would come from your own backend that means you’ll be able to segment your customers, define lifecycles or create playbooks based on calculated metrics using these data points depending on the geographical location of your data (germany, ireland or us), you will need to whitelist a list of ips before activating the data warehouse frankfurt business 3 123 52 1563 67 152 22418 159 43 17018 194 219 2193 74 25 43 ireland 34 253 103 15, 176 34 236 120, 54 73 1 213 us business 3 142 88 1818 188 66 1843 19 0 1973 140 205 1813 140 83 245 activation 1\ sign in to custify and navigate to the integrations page 2\ select the data warehouse integration 3\ click new sync and then new source, and select snowflake 4\ fill in your connection information we recommend creating a dedicated user and role for custify to access your snowflake data warehouse it must have access to the warehouse and database you want to connect to custify here is a sample of how to create a user and role with access create role if not exists \<your role>; create user if not exists \<your user> password= ; grant role \<your role> to role sysadmin; grant usage on warehouse \<your warehouse> to role \<your role>; grant role \<your role> to user \<your user>; grant usage on database \<your db> to role \<your role>; grant usage on all schemas in database \<your db> to role \<your role>; grant select on all tables in database \<your db> to role \<your role>; grant select on future tables in database \<your db> to role \<your role>; grant select on all views in database \<your db> to role \<your role>; 5\ select which custify object you want to create from your data people, events, or companies 6\ select the source data in your snowflake data warehouse then, select the namespace and table in your data warehouse that contains the source data 7\ map the fields in your source data to the fields expected by custify

