Google Cloud Storage
Type of Support | Read & Write |
Alteryx Tools Used to Connect
Standard Workflow Processing
Google Cloud Storage (GCS) is a web service for storing and accessing files on Google Cloud Platform. The service combines the performance and scalability of the Google cloud with advanced security.Using Google Cloud Storage is only supported while also using DCM.
Set Up Google Cloud Storage Connection
Drop Input (or Output) tool on canvas and select Set Up Connection(Make sure DCM is enabled. For more information on managing data sources in DCM, go to DCM - Designer).
In the Data Connections window, go to Data sources and select Quick Connect for Google Cloud Storage (GCS).
Select + New in the Connection Manager window.
Define the Data Source Name and Catalog (Project ID).
Select Save.
Select + Connect Credetial.
Choose Authentication Method:
Google Workload Identity Federation With Entra ID - to access Microsoft Entra protected resources without needing to manage secrets.
Sign-in with Google - fill in Credential Name to provide a token storage name.
Sign-in with Google–Private - provide your OAuth Application (Client ID and Client Secret) with OAuth Tokens.
Select Create and Link.
Select Connect.
You are redirected to your browser to sign in and allow your account to connect.
You can now browse and select your objects from GCS in the left panel.
For an Output tool, you can choose to Add Folder or Add File to selected bucket or folder. Also, you can select Output Actions for Every Run:
Create Only
Overwrite
Skip Existing
Hit Select to select your file.
Based on the file type selected, Designer automatically pre-selects the type of file from the dropdown. However, you can select any other file type. Designer shows all the file specific options according to the file type selected. Configure the file options and select Confirm.
You can review the configuration in the overview, including the selected target and the set up of file specific options.
Now you can run the workflow.
File Format Support
You can read and write the following file formats.
File Format | Read | Write |
|---|---|---|
AVRO | YES | YES |
CSV | YES | YES |
DBF | YES | YES |
HTM | NO | YES |
JSON | YES | NO |
KML | YES | YES |
PARQUET | YES | YES |
QVX | YES | YES |
SAS7BDAT | YES | YES |
SAV | YES | YES |
XLSM | YES | YES |
XLSX | YES | YES |
XML | YES | NO |
YXDB | YES | YES |