How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?
| 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
Mail & Deploy Report
Snowflake Server Database datasource
Customer and corresponding Orders
Customer
The Customer number is a parameter, for design purposes, the default is set to 270001
CUSTOMER element
ORDERS element
Preparation Action
Datasource Object
ORDERS Repeater Element
Preparation Action
Levels
Preparation Action
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.
Related Articles
How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?
FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...What is Report Culture Awareness, and how does it impact Mail & Deploy reports?
FIRST CREATED ON 30 Apr 2020 I AUTHOR Emma Camacho A culture is a set of rules that specify how numbers and dates are formatted (Windows Regional Settings). Generally speaking, the culture defines in what format numbers and dates are being presented ...How to use page breaks in Excel when using a repeater (same sheet)? (2/2)
FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Excel when using repeaters, this time the Debug version of the report. The definitions are the same as the example in How to use page breaks in Excel ...How to use page breaks in Excel when using a repeater (same sheet)? (1/2)
FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Excel when using repeaters. The output should look like this: Each page will have 4 tables and the last one might have less. The template looks like ...How to activate Qlik Sense Themes in Mail & Deploy?
FIRST CREATED ON 14 Jun 2023 I AUTHOR Emma Camacho Qlik Sense themes offer a powerful way to customize the appearance of your reports. By applying themes, you can easily align the look and feel of your reports with your brand or preferred style. ...