Page History

Goals

Our ultimate goal is to use AWS RDS for both input and output of mosaic data set creation. Ideally, input will be a staging RDS and output will be a production RDS.

It is not clear how to set AWS RDS as output in MDCS xml file.

<Workspace>
    <WorkspacePath>md</WorkspacePath>
    <Geodatabase>Amberg</Geodatabase>

The above item is always local based on documentation. Ask Abhijit if a connection file can be used herethere for output.

It is also not clear how we can replace .csv file in MDCS xml file. Can the table entry be an AWS RDS?

	<AddRaster>
          <dataset_id>power</dataset_id>
          <raster_type>Table / Raster Catalog</raster_type>
          <Sources>
            <data_path>Z:\home\arcgis\data\CERES.csv</data_path>
          </Sources>
          <filter>*</filter>
     </AddRaster>

Step-by-step guide for AWS RDS Output

1. Create .sde connection [2].

2. Use the .sde file to specify mosaic destination (e.g., test_mosaic) using CLI. It will ignore Geodatabase in MDCS.xml file.

   Code Block
   language powershell
   PowerShell>%py% MDCS.py -i:MDCS_Solar.xml -m:Z:\home\arcgis\etc\aws_rds_geodb_conn.sde\test_mosaic

Step-by-step guide for AWS RDS Input

1. Create .sde connection file  [2].
2. Create a table called test_csv in AWS RDS from CERES.csv file using ArcGIS Pro Geoprocessing Tool in Catalog window.

3. Use the .sde file to specify table destination.

   Code Block
   language xml
   <AddRasters> <AddRaster> <dataset_id>power</dataset_id> <raster_type>Table / Raster Catalog</raster_type> <Sources> <data_path>Z:\home\arcgis\etc\aws_rds_geodb_conn.sde\test_csv</data_path> </Sources> <filter>*</filter> </AddRaster> </AddRasters>

4. Run the MDCS script as usual.

References

1. https://github.com/Esri/mdcs-py/blob/master/Documentation/MDTools_ReadMe.pdf
2. https://pro.arcgis.com/en/pro-app/tool-reference/data-management/create-database-connection.htm

Related articles

...