Skip to main content
Documentation

Snowflake

SnowflakeExternal LinkThis link leads to an external website and will open in a new tab is a cloud-based data platform for data warehousing, analytics, and data sharing across multiple cloud providers.

Files.com integrates with Snowflake through the Files.com S3-Compatible Endpoint. Snowflake connects to your Files.com site the same way it connects to any Amazon S3 bucket, and loads data directly from Files.com folders into Snowflake. Snowflake supports this through its S3-compatible storageExternal LinkThis link leads to an external website and will open in a new tab feature, which lets you use your Files.com site's S3 endpoint as a Snowflake external stage.

Configuring Files.com

Your Files.com site includes an S3-Compatible Endpoint. Generate an S3-compatible API Key to create the access key ID and secret access key that Snowflake needs. The API Key must be associated with a user account on your site.

Configure the Files.com folder permissions for the folder you want Snowflake to access so that the user associated with the access key has access.

Verify that the user can access the folder and see the expected files before configuring Snowflake.

Configuring Snowflake

Refer to the Snowflake documentation on working with S3-compatible storageExternal LinkThis link leads to an external website and will open in a new tab for details on how to access your Files.com site from Snowflake.

Snowflake does not allow connections to custom S3-compatible endpoints until you contact Snowflake supportExternal LinkThis link leads to an external website and will open in a new tab and ask them to enable endpoint connections to s3.files.com. Until that is in place, connection attempts return the error SQL compilation error: Endpoint s3.files.com not allowed.

The bucket name for your Files.com site is your custom subdomain. If your custom subdomain is mysite.files.com, the bucket name is mysite.

The endpoint for your Files.com site is s3.files.com.

Use your Files.com S3-Compatible Endpoint credentials when configuring your Snowflake stage. For example:

CREATE STAGE my_files_dot_com_stage
  URL = 's3compat://mysite/path/to/folder/'
  ENDPOINT = 's3.files.com'
  CREDENTIALS = (AWS_KEY_ID = 'your_access_key_id' AWS_SECRET_KEY = 'your_secret_access_key')

Verify that Snowflake can successfully load and unload data filesExternal LinkThis link leads to an external website and will open in a new tab from your Files.com folder before putting the integration into production.

Troubleshooting

Most issues come from incorrect access permissions. Confirm that the S3-Compatible Endpoint access key Snowflake is using, and its associated user, have the correct permissions on the target folder, including "Read" permissions at a minimum.

Confirm that Snowflake is configured to use s3.files.com as the endpoint URL. Custom domains are not supported for the endpoint URL.