Page 18 - Demo

TABLE 2-1 (continued)
Data Sharing Approach
Pros
• Well-known and long-established protocol
• Availability of a wide range of FTP client software and services
Cons
File transfer protocol (FTP) — (see Figure 2-1)
• Schema changes require a great deal of lead time
• Must acquire FTP client software, server, and/or service
• FTP account admin setup and overhead required
• Large data sets must be deconstructed and broken down in size to facilitate faster data transfers
• Not natively secure; requires custom encryption scripting or secure service
• Mirror effort required on recipients’ end (receive, decrypt, reconstruct data)
• Efforts must be repeated with each new update to a shared data set
FIGURE 2-1: Multiple steps of a typical legacy FTP-based data sharing workflow.
Conventional Data Sharing: Time-to-Value Delays
Conventional data sharing methods can create other challenges that cause more delays and require more assistance from your IT teams, including:
12 Data Sharing For Dummies, Snowflake Special Edition
These materials are © 2018 John Wiley & Sons, Inc. Any dissemination, distribution, or unauthorized use is strictly prohibited.