A company's Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that are placed on an FTP server and uploaded to Snowflake manually. The files are changed several times each month, and the ingestion process needs to be adapted to accommodate these changes.
What would be the MOST efficient solution?
The most efficient solution would be to ask the partner to create a share and add the company's account. By utilizing Snowflake's data sharing feature, data can be shared between accounts without the need for data movement or complex configurations. This method ensures that the data is readily available and up-to-date, reducing the overhead of managing and adapting to file changes and eliminating manual uploads.
A. No, users sharing a share that includes a database cannot see the files contained in an stage within that database by default.
json is prepared from some table(tables) and extracts to FTP. they can create a share with secure view which will contain all data with logic in place
already the other user is a snowflake user, so share would be the optimal solution.