SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ73

Data Ingestion and Data Preparation

A company’s Architect needs to identify an efficient method to obtain data from an external partner who is also a Snowflake user. The current approach relies on daily JSON extracts placed on an FTP server and manually uploaded to Snowflake. The files change several times per month, and the ingestion process must be adjusted to handle those changes.

What would be the MOST efficient solution?

Explanation

Snowflake Secure Data Sharing lets a provider create a share, add a consumer’s Snowflake account, and make shared database objects available without copying or transferring the data. Updates to existing shared objects are immediately available to consumers, eliminating the FTP and manual-ingestion workflow. Reader accounts are designed for third parties that do not already have Snowflake accounts.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!