How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?

Modified on Fri, 30 Aug at 12:43 PM

FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho

Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started:

Use case: Display Orders and Orders' Line items from one Customer from the Snowflake sample database

Here are the Snowflake tables:

CUSTOMER

ORDERS

LINEITEM

Mail & Deploy Report

How to get there?

Snowflake Server Database datasource

Report Template

Customer and the corresponding Orders

Orders and the corresponding Line items

PARAMETERS

Customer

The Customer number is a parameter, for design purposes, the default is set to 270001

CUSTOMER element

ORDERS element

ORDERS Repeater Element

Preparation Action

ORDERS Repeater Element

Levels

LINEITEM Element

Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.