Skip to main content

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. Using Snowflake's S3-compatible storageExternal LinkThis link leads to an external website and will open in a new tab feature, you point a Snowflake external stage at your site's S3 endpoint and load data directly from Files.com folders.

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.

Grant Full folder permissions on the folder you want Snowflake to access to the user associated with the access key.

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.

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 by default. You can use Custom Domains to customize your endpoint for S3 connections. If you are using a custom domain for your S3 endpoint, you must contact Snowflake support and ask them to enable connections to that domain.

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')

Point the stage at the folder that contains your data files. Your site's S3-compatible endpoint returns a full recursive listing, so a stage pointed at a parent folder picks up files in every subfolder underneath it, not just the files directly inside it.

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.