Hello GoodData team and community! We are trying ...
# gooddata-platform
j
Hello GoodData team and community! We are trying to implement the object renaming utility, do you guys have actual examples in code on how to use it? I'm referring to the documentation https://help.gooddata.com/doc/growth/en/data-integration/data-preparation-and-distrib[…]reference/brick-reference/utilities/object-renaming-utility/. We want to utilize it using API calls. Thank you in advance for any responses.
m
Hello Jeremy, there are some examples in the documentation you linked upon which you can build your own implementation, e.g., the queries stored in an S3 bucket may look like this:
Copy code
{
  "s3_client": {
    "bucket": "rename",
    "accessKey": "123456789",
    "secretKey": "secret",
    "region": "us-east-1",
    "serverSideEncryption": "true"
  },
  "queries_input_source": {
    "type": "s3",
    "file": "folder/object_rename.csv"
  }
}
The queries obtained from ADS
Copy code
{
  "ads_client": {
    "username": "<mailto:john.doe@example.com|john.doe@example.com>",
    "password": "secret",
    "ads_id": "rtmmgjsqc4zmf64egtu6l6xv2xhxempi"
  },
  "queries_input_source": {
    "type": "ads",
    "query": "SELECT source_identifier, object_identifier, object_name, deprecated, summary, data_product FROM object_rename;"
  }
}
You may create the brick via the API following the calls to Create a Data Loading Process and then you may executive with the call documented in Executions of Data Loading Processes