Although there is no direct integration between Snowflake and the Files.com platform, both solutions integrate with Amazon S3, Google Cloud, and Microsoft Azure, allowing you to connect Snowflake's data import capabilities with Files.com data transfer capabilities.
Snowflake allows you to import data from files stored within cloud storage solutions, such Amazon S3, Google Cloud, and Microsoft Azure.
Files.com allows you to connect cloud storage locations, such Amazon S3, Google Cloud, and Microsoft Azure, to the Files.com platform so that users, systems, and scripts can transfer files to those storage locations using common methods, such as web browsers, SFTP and FTP clients, Files.com Apps, WebDAV, and RESTful APIs.
Configuring Snowflake and Files.com to use the exact same cloud storage provides a method for users to upload data files, such as CSV format files, directly to the cloud storage that Snowflake uses to import these data files from.
Refer to the Snowflake documentation about bulk loading for details on how to import data using the COPY INTO <tablename> command.
Verify that Snowflake can bulk load data from your cloud storage.
For example, if you're using Amazon S3, then you should be able to successfully bulk load data files using a command such as:
COPY INTO MYTABLE from 's3://mybucket/path/to/folder_containing_csv_files/'
credentials = (aws_key_id='xxxx' aws_secret_key='xxxxx' aws_token='xxxxxx');
Use the Remote Mount feature to connect your Amazon S3, Google Cloud, or Microsoft Azure storage to Files.com.
For example, you can create a top-level folder in Files.com named Upload CSV Files Here and configure the Remote Mount settings so that this folder connects to the s3://mybucket/path/to/folder_containing_csv_files/ folder in your Amazon S3 bucket.
Configure the Files.com permissions for the Remote Mount folder to allow access for the desired users or groups. For example, configure the permissions of the Upload CSV Files Here folder so that users Amy, Bob, and Charlie have permission to access and upload into this folder.
Verify that the users can now upload files, and that the files are directly written to your cloud storage location. For example, files uploaded into the Upload CSV Files Here folder will automatically appear in the s3://mybucket/path/to/folder_containing_csv_files/ folder.
Most issues are caused by incorrect access permissions.
- Make sure that Files.com has the correct access permissions to your cloud storage, including create, read, update, and delete permissions.
- Make sure that the cloud storage key and token being used by Files.com have the correct permissions, including create, read, update, and delete permissions.
- Make sure your users and groups have the correct access permissions to the Remote Mount folder, with a minimum of at least write permission.
Get Instant Access to Files.com
The button below will take you to our Free Trial signup page. Click on the white "Start My Free Trial" button, then fill out the short form on the next page. Your account will be activated instantly. You can dive in and start yourself or let us help. The choice is yours.Start My Free Trial