
Jovan Popovic π·πΈ
@JovanPop_MSFT
Followers
1K
Following
271
Media
495
Statuses
2K
Principal program manager (Microsoft). Working on Microsoft Fabric (Warehouse).
Republic of Serbia
Joined January 2016
Do you need DATA_SORCE option in BULK INSERT statement in #Fabric #DataWarehouse? to import files using custom auth and use relative file paths? If you are using this, vote for this idea:
community.fabric.microsoft.com
The BULK INSERT Statement in SQL Server/Azure SQL has a DATA_SOURCE option that enables importing files from the paths relative to the DATA_SOURCE location, and also adding a custom authentication in...
0
1
2
BULK INSERT statement is available in #Fabric #DataWarehouse. With the BULK INSERT statement, you can easily reuse the data ingestion code that you are using in #SQLServer and #AzureSQL
blog.fabric.microsoft.com
The BULK INSERT statement is generally available in Fabric Data Warehouse. The BULK INSERT statement enables you to ingest parquet or csv data into a table from the specified file stored in Azure...
0
3
8
The #OPENROWSET function is generally available in #MicrosoftFabric #DataWarehose and #SQL endpoint for #Lakehouse:
blog.fabric.microsoft.com
The OPENROWSET function is generally available in Fabric Data Warehouse and Fabric SQL endpoints for Lakehouse and Mirrored databases. The OPENROWSET function enables you to easily read Parquet and...
0
2
5
#OPENROWSET function in #Fabric #DataWarehouse can read data only from #ADLS and #Azure blob storage. If you think that One Lake access would be useful in your scenarios - you can vote for this idea:
community.fabric.microsoft.com
OPENROWSET function can read the files from Azure Data Lake storage or Azure Blob storage.Β It would be useful to enable OPENROWSET to also read files form Fabric One Lake and access the files in...
0
0
2
Are you using OPENROWSET to parse #JSON files? Vote for the native support for the #json file sources in OPENROWSET:
community.fabric.microsoft.com
Fabric Warehouse currently supports theΒ OPENROWSETΒ function, which allows you to read CSV files directly. However, when it comes to reading JSON files, you need to use a workaround. This involves...
1
0
1
Do you want to find out what's new in #FabricDW? Join me at #SQLKonferenz on #Fabric session covering the latest features in #Fabric #DataWarehouse, with a discount "SP25PR" that you can use at !.
shop.sqlkonferenz.de
0
2
4
Christmas special: Spatial in Fabric DW - you can learn about the spatial capabilities in #Fabric DW in this article:
linkedin.com
In today's data-driven world, data warehouses play a crucial role in enabling organizations to perform complex analytical queries. These warehouses are designed to provide reporting capabilities on...
0
1
11
Halloween announcement π: We have started public preview of VARCHAR(MAX) and VARBINARY(MAX) types in #Fabric #Data #Warehouse via @MSFabric.
blog.fabric.microsoft.com
Fabric Data Warehouse is a modern data warehouse optimized for analytical data models, primarily focused on the smaller numeric, datetime, and string types that are suitable for analytics. For the...
0
3
9
Do you need #OPENROWSET function in #Microsoft #Fabric #Datawarehouse? I'm exploring do we need to add it to #DW, so if you find it useful vote for this idea and optionally leave a comment describing how would you use it:
community.fabric.microsoft.com
Data providers typically deliver data in formats such as parquet, JSON, or CSV. In traditional data warehouse scenarios, these files often land in a persistent staging area. Many organize these...
0
2
3