Data Transfer to GCP using Alteryx Designer

[indakath]

Hello I want to transfer data to Google Cloud storage GCP using Alteryx designer but its not possible using simple output tool, I got to know there is tool Google Cloud storage tool in  Alteryx designer itself but I cant see that. Is there anyone who knows about it and can share output tool with configuration how to transfer to GCP table.

I have made connection required but not able to create table it has error while posting data to GCP 

Thanks AK 

[aatalai]

@indakath is there any part of GCP you want in specfic?

Here are a few connectors that  might help

https://help.alteryx.com/current/en/designer/data-sources.html#idm44949499107552

Scroll down to the google section 

Let me know how you get on

[indakath]

Hi Thanks for your response but I was looking this Google Big query tool in Alteryx designer but unable to see. Is that list of supported connection you have mentioned are available in Alteryx Designer or its an API kind of which are to be installed . Would be nice if you share that particuler tool Google Big Query in Alteryx Desktop designer .Thanks 

[aatalai]

Designer, unfortunately, I don't have access to GCP so I can't upload a workflow, try the data input way/the in db way, let me know how you get on

Try this page

https://help.alteryx.com/current/en/designer/data-sources/google-bigquery.html#idm44949496014368

[indakath]

There are only few supported connection visible in Alteryx 

[aatalai]

try the regular green data input tool like the article suggested or the in db tools 

https://help.alteryx.com/current/en/designer/data-sources/google-bigquery.html#idm44949496014368

[indakath]

Slightly confused, I want to transfer data form one source (form ABC DB Table ) making data changes in alteryx and would like to post it on GCP not sure how input tool will help to connect, I think output toll will help but the alteryx output tool is there is working for me .

[aatalai]

@indakath insert a green data input, press use DCM, then set up connection, then click on data sources and then scroll to big query

[apathetichell]

Assuming you have authenticated to your GCP project locally - use a formula tool to script GCP cli into a .bat file. Use a run command tool to execute your .bat file. Add parameters to your formula tool for filename/bucket. You MUST create your file locally first.

Your syntax should be something like: 

gsutil cp *.txt gs://my-bucket