question

BHATSCShivaranjini-5230 avatar image
0 Votes"
BHATSCShivaranjini-5230 asked HimanshuSinha-MSFT commented

Blob file could not be read in dwh sp.

Hello,
I'm trying to read the blob file to dwh but in container I could see the blob showing.
My DWH is Performance level is 100c and I'm reading that file thru sp called in DWH. This sp reads the data directly from parquet file. PFA screenshot

98112-trip-stop-history.jpg


azure-data-factory
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @BHATSCShivaranjini-5230 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·
HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered HimanshuSinha-MSFT converted comment to answer

Hello @BHATSCShivaranjini-5230 ,
Thanks for the ask and using the Microsoft Q&A platform .
My apoloziges for not understanding the ask here , are you trying to view the file from the Azure portal ? if yes then there is a limitation of 2.1 MB , what you can do is download the file and view the same locally .


Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BHATSCShivaranjini-5230 avatar image
0 Votes"
BHATSCShivaranjini-5230 answered HimanshuSinha-MSFT commented

Hello Himanshu,

The issue is unlreleated to size of the parquet files. The database scoped credentials were wrong hence the I was facing issue.

Thanks

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @BHATSCShivaranjini-5230 ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries .
Thanks
Himanshu

0 Votes 0 ·