Microsoft Fabric : External Shortcuts :Amazon S3(AWS) :Detailed Demo

This tutorial will explain the following topics under Fabric Shortcuts :

1) Brief Introduction of Shortcuts
2) Setup walkthrough in AWS required for Fabric to access Data
3) How to Create S3 Shortcuts on Lakehouse( Both File and Table Shortcuts) and KQL database - Used Delta Format and Iceberg Format
4) How Data Updates in S3 Data reflect in Fabric Shortcuts using Metadata Refresh Cycles
5) How to Manage Shortcuts
6) How to Create Shortcut on Shortcut
7) How to manage and delete Shortcut Connections
8) Limitations of S3 Shortcuts

#dataengineering #fabric #microsoftfabric #datanalytics #fabric2025 #fabricshortcuts #shortcuts #awss3 #s3 #externalshortcuts #latesttechnology #microsoftlatest #latest #engineering #bigdataanalysis #apachespark #MicrosoftFabric

Brief Introduction of Shortcuts : 00:02
Setup walkthrough in S3 for Fabric to access S3 Storage data : 02:18
How to Create S3 Shortcuts on Lakehouse( Both File and Table Shortcuts) : 06:22
Setting Up Shortcut Connection and File Shortcut in Lakehouse : 08:52
Creation of Delta table from a File in Lakehouse : 20:40
Creation of Table Shortcut in Lakehouse : 22:39
How Data Updates in S3 Data reflect in Fabric Shortcuts using Metadata Refresh Cycles : 25:00
Running EMR Serverless to refresh bronze data after updating Input file in csv : 27:03
Validating date updates in Table and Files Shortcut : 28:39
Manage Shortcut connection : 33:00
Creation of Event House Item for KQL Database : 34:04
Creation of Shortcut in KQL Database : 34:36
Running KQL queries on Shortcuts data : 36:27
Limitations of S3 Shortcuts: 38:16
Some additional Cases : 39:13
Shortcuts on Shortcuts for Delta Format and Iceberg Format : 40:49
Delete Connections including Shortcut connections : 44:20

Additional Links:
S3 Shortcut limitations : https://learn.microsoft.com/en-us/fab...