Welcome to Zuora Product Documentation

Explore our rich library of product information

Configure Zuora-managed S3 for Snowflake (Storage Integration, Inline)

Use these steps when your Snowflake environment uses a storage integration to control access to external S3 locations, but you do not need separate stages for every data flow.

With the Inline model, Mediation uses the storage integration with inline S3 URLs, so access is governed by the integration configuration. In this model, you typically do not need to create stages for Mediation: Snowflake uses the storage integration and inline URLs directly to control access to Zuora-managed S3.

Note: As a part of the setup, you need to coordinate with Zuora Global Support to complete the configuration.
  1. On the Setup step of the wizard, under Choose Setup Option, select Storage Integration.
  2. Under Data Access Model, select Inline (DEFAULT).
  3. Expand the Storage Integration Setup Instructions and complete the Snowflake-side configuration as described.
  4. Create a Snowflake Storage Integration.
    CREATE STORAGE INTEGRATION <storage_integration_name>
      TYPE = EXTERNAL_STAGE
      STORAGE_PROVIDER = S3
      STORAGE_AWS_ROLE_ARN = 'arn:aws:iam::<aws_account_id>:role/<role_name>'
      ENABLED = TRUE
      STORAGE_ALLOWED_LOCATIONS = ('s3://zuora-managed-mediation-prod/exports/');
  5. Describe the storage integration.
    DESC STORAGE INTEGRATION <storage_integration_name>;
  6. From the DESC output, collect the STORAGE_AWS_IAM_USER_ARN and STORAGE_AWS_EXTERNAL_ID values and raise a support ticket to share these values with Zuora.
  7. Grant USAGE on the integration to the role.
    GRANT USAGE ON INTEGRATION zuora_s3_int TO ROLE <ROLE_NAME>;
  8. Grant required privileges to the user.
  9. Disable the flags PREVENT_UNLOAD_TO_INLINE_URL and PREVENT_LOAD_FROM_INLINE_URL.
  10. At the bottom of the Setup page, select the checkbox I have completed the required setup in Snowflake.
  11. Review the Snowflake User & Role Grants section if needed, then click Continue to move to the Validate step.