Good day, I would like to know if with the latest version of Matillion ETL, any component can create, update, delete tables from a database such as Oracle or Mysql, I tried the Database Query component and it does not work.
Capture attached.
@michael.cruz-experis - Matillion's core capabilities lie in creating and maintaining tables / database objects in the destination system (Snowflake, BigQuery, Redshift).
METL has limited support in unloading data and performing reverse ETL to source systems (like Oracle, MSSQL, MySQL). Your best bet would be to create a SQL script with your DDL statements and execute them using the "Bash Script" component before loading data.