Synapse df.to_parquet Write to Data Lake error

SoonJoo@Genting 241 Reputation points
2022-09-09T04:58:53.383+00:00

I am having this problem when trying to write the parquet file using the df.to_parquet command in the notebook. The command was working perfectly but now it does not work as intended.

import fsspec
import pandas
from datetime import datetime

if ('' + output_timestamp == ''):
output_timestamp = datetime.utcnow().isoformat().replace(":", "") + "0Z"

sas_key = TokenLibrary.getConnectionString(linked_service_name)

fsspec_handle = fsspec.open(output_folder_path_full + '/' + output_timestamp + '/' + output_file_name, sas_token=sas_key, mode='wt')
with fsspec_handle.open() as f:
f.write(response.text)

module 'fsspec_wrapper' has no attribute 'AzureBlobFileSystem'

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,459 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,844 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2022-09-12T21:50:03.81+00:00

    Hello @SoonJoo@Genting ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is get rid of the error called out above , please do let us know if its not accurate.
    It appears that the the package fsspec is not the latest one and hence this issue .
    Please update the ppackage and that will resolve the issue .
    install fsspec
    More on the same issue here
    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.