![]() Relative file paths can be used to directly read data from shortcuts. Spark notebooks and Spark jobs can utilize shortcuts that are created in OneLake. This allows Spark, SQL, Real-Time Analytics and Analysis Services to all utilize shortcuts when querying data. Shortcuts just appear as another folder in the lake. Shortcuts are transparent to any service accessing data through the OneLake API. To query the shortcut, use the "external_table" function of the Kusto Query Language.Īny Fabric or non-Fabric service that can access data in OneLake can utilize shortcuts. The KQL database treats shortcuts like external tables. When you create a shortcut in a KQL database, it appears in the "Shortcuts" folder of the database. Table discovery doesn't happen in the “Files” folder. They can be created at any level of the folder hierarchy. In the “Files” folder, there are no restrictions on where you can create shortcuts. If the target of the shortcut contains data in the delta\parquet format, the Lakehouse will automatically synchronize the metadata and recognize the folder as a Table. Shortcuts aren't supported in other subdirectories of the "Tables" folder. In the “Tables” folder, you can only create shortcuts at the top level. The “Tables” folder represents the managed portion of the Lakehouse while the “Files” folder is the unmanaged portion of the Lakehouse. Lakehouses are composed of two top level folders: The “Tables” folder and the “Files” folder. When creating shortcuts in a Lakehouse, it’s important to understand the folder structure of the item. Furthermore, the shortcuts created within these items can point to other OneLake locations, ADLS Gen2 or Amazon S3 storage accounts. Shortcuts can be created both in Lakehouses and KQL Databases. If the target path is moved, renamed, or deleted the shortcut can break. If a shortcut is deleted, the target remains unaffect. They're an independent object from the target. ![]() Shortcuts behave similar to symbolic links. Shortcuts appear as folders in OneLake and can be used transparently by any experience or service that has access to OneLake. The location that the shortcut appears is known as the "Shortcut" path. The location that a shortcut points to is known as the "Target" path of the shortcut. The location can be internal or external to OneLake. Shortcuts are objects in OneLake that point to other storage locations. Microsoft makes no warranties, expressed or implied, with respect to the information provided here. This information relates to a prerelease product that may be substantially modified before it's released. ![]() Microsoft Fabric is currently in PREVIEW.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |