Add credentials
- Create a new pipeline or open an existing pipeline.
- Expand the left side of your screen to view the file browser.
- Scroll down and click on a file named
io_config.yaml. - Enter the following keys and values under the key named
default(you can have multiple profiles, add it under whichever is relevant to you)
GOOGLE_APPLICATION_CREDENTIALS environment variable is set (e.g. to the path of your service account JSON), you can also use the IO class without adding keys to io_config.yaml; otherwise use with_config as shown below.
Using Python block
- Create a new pipeline or open an existing pipeline.
- Add a data loader or transformer block (the code snippet below is for a data loader).
-
Select
Generic (no template). -
Enter this code snippet (note: change the
config_profilefromdefaultif you have a different profile): - Run the block.
Export data to Google Cloud Storage
Supported formats
Google Cloud Storage supports loading and exporting:.csv.json.parquet
Permissions
Ensure your Google Cloud service account has the appropriate roles, for example:- Storage Object Viewer – to read objects
- Storage Object Creator – to write objects
- Storage Object Admin – for full read/write/delete