Note: For Oracle, users must provide an Oracle JDBC driver manually, because this is not distributed with Matillion ETL.
Advanced Mode is the default setting for this component. In most use cases, this mode will be sufficient.Īdvanced: this mode will require the user to write an SQL-like query to call data from the RDS database. Do not modify the target table structure manually.īasic: this mode will construct a query using settings determined by the user in the Data Source, Data Selection, and Data Source Filter properties. Setting the Load Option Recreate Target Table to Off will prevent both recreation and truncation. Otherwise, the target table is truncated. If the target table undergoes a change in structure, it will be recreated. Warning: This component is potentially destructive.
That is to say, retrieving data and loading that data into a table, from which users can perform data transformations to enrich and manage the data in permanent tables. The RDS Query component enables users to run an SQL query on an RDS database and then copy the results to a table via Amazon S3 (Amazon Simple Storage Service).