Trying to install Big query Input tools v2.0.1 on Alteryx Version 2020.3
When trying to install i am getting this error attached below.
Please help me how can i overcome this error to use big query Input Tool.
Error Message
@rkapoor Thanks for your Assistance.
It Works well with 2020.2 and 2020.4 as you said.
For 2020.3 PFB YXI File
(Received from Alteryx Support)
@harshal98 what version of Designer are you installing this into?
@rkapoor 2020.3.7
@harshal98 can you raise a Support ticket on this by emailing support@alteryx.com.I believe this seems to work with 2020.2 and 2020.4 so might be a compatibility issue with 2020.3.
@rkapoor Thanks Man....Have Done the same.
The installation is working fine on 2020.2 and 2020.4 ... you sure about this?
So i can try downloading the same if no walkaround!
@harshal98 I tried the tool with 20.2 and 20.4 and it works fine for me on this end. If you can upgrade to 20.4 and download the tool and reinstall - it should work. In parallel, raise the ticket with Support also for your 20.3 issue.
Brilliant, thanks for this! We've had a bit of a saga this week in trying to get virtually the same thing working and seeing exactly the same error. I tried rolling back to 2020.2 as suggested (we've already found a problem with the CReW List Runner in 2020.4 so that wasn't an option) but found I was still getting exactly the same cryptography error as I was seeing on 2020.3.
As a last throw of the dice before raising a support call I tried installing the YXI file provided to Harshal by Alteryx Support for 2020.3 and it's done the trick!
So if you happen to hit this error on 2020.2 then it's worth knowing this fix will also work on that version...
This issue is being investigated by Alteryx Product and Engineering teams.
We apologize for any inconvenience this might be causing on earlier versions than Designer 2020.4.One work-around that has been helping is adding "cryptography==2.9.2" to the requirements.txt file of the Connector tool.Please note this can also affect other Python-based Connectors other than BigQuery, like DynamicsCRM and ADLS.
The requirements.txt file can be found in the tool folder and edited with notepad. If you encounter any issues with this please do contact Alteryx Support, we are happy to help.
Thanks,
Sabrina
Not only earlier versions even in Alteryx 2021.1 we have this issue
I didn't have this issue when I was working with 2020.4. Once I upgraded to 2021.1 my Big Query Connectors are not working, in spite of working through every single work around mentioned here like downloading and installing the crytography.yxi file and checking for the same in the requirements.txt (looks like they both are the same work around).
When BQ Connector can work in 2020.4 , why not in 2021.1 ? This is problem that needs a fixture asap since it's not great to write data in csv and append them to tables while the whole job can be done in a click of a button.
Hi @Sudarsana_R I understand what you mean. Can you raise a ticket to support@alteryx.com on this, and they will be able to look into this as soon as it is possible
Error Message
