将csv上传到雪花时出错

Question

尝试上载大小为100 in的csv，并在tmp中创建压缩文件后获得此错误。

   data = sf_file_transfer_agent.result()
  File "/apps/tools/python/python36/lib/python3.6/site-packages/snowflake/connector/file_transfer_agent.py", line 722, in result
    "errno": ER_FAILED_TO_UPLOAD_TO_STAGE,
  File "/apps/tools/python/python36/lib/python3.6/site-packages/snowflake/connector/errors.py", line 258, in errorhandler_wrapper
    error_value,
  File "/apps/tools/python/python36/lib/python3.6/site-packages/snowflake/connector/errors.py", line 309, in hand_to_other_handler
    cursor.errorhandler(connection, cursor, error_class, error_value)
  File "/apps/tools/python/python36/lib/python3.6/site-packages/snowflake/connector/errors.py", line 195, in default_errorhandler
    cursor=cursor,
snowflake.connector.errors.OperationalError: AttributeError("'StorageCredential' object has no attribute '_command'",)

Answer 1

不建议加载非常大的文件(例如100 GB或更大的文件)。尝试将文件丢弃到100-250 MB大小(压缩)并尝试.