S3

​

Add credentials

1. Create a new pipeline or open an existing pipeline.
2. Expand the left side of your screen to view the file browser.
3. Scroll down and click on a file named io_config.yaml.
4. Enter the following keys and values under the key named default (you can have multiple profiles, add it under whichever is relevant to you)
   Copy

   version: 0.1.1
   default:
     AWS_ACCESS_KEY_ID: ...
     AWS_SECRET_ACCESS_KEY: ...
   

​

Using Python block

1. Create a new pipeline or open an existing pipeline.
2. Add a data loader or transformer block (the code snippet below is for a data loader).
3. Select Generic (no template).
4. Enter this code snippet (note: change the config_profile from default if you have a different profile):
   Copy

   from mage_ai.settings.repo import get_repo_path
   from mage_ai.io.config import ConfigFileLoader
   from mage_ai.io.s3 import S3
   from os import path
   from pandas import DataFrame
   
   if 'data_loader' not in globals():
       from mage_ai.data_preparation.decorators import data_loader
   
   
   @data_loader
   def load_from_s3_bucket(**kwargs) -> DataFrame:
       config_path = path.join(get_repo_path(), 'io_config.yaml')
       config_profile = 'default'
   
       bucket_name = '...'  # Change to your bucket name
       object_key = '...'   # Change to your object key
   
       return S3.with_config(ConfigFileLoader(config_path, config_profile)).load(
           bucket_name,
           object_key,
       )
   

5. Run the block.

​

MinIO Support

AWS_ENDPOINT: your_endpoint:port #example: "https://play.min.io:9000"

​

Errors

​

Permissions

• s3:GetObject
• s3:PutObject
• s3:ListBucket

• Read data from S3 (e.g. .csv, .parquet, .json)
• Write query results or transformed data to S3
• List contents of a bucket when needed