append
Astro SDKAppend the source table rows into a destination table.
Access Instructions
Install the Astro SDK provider package into your Airflow environment.
Import the module into your DAG file and instantiate it with your desired params.
Parameters
source_tableRequiredastro.sql.table.TableContains the rows to be appended to the target_table (templated)
target_tableRequiredastro.sql.table.TableContains the destination table in which the rows will be appended (templated)
columnsList[str] | Tuple[str] | Dict[str, str]List/Tuple of columns if name of source and target tables are same. If the column names in source and target tables are different pass a dictionary of source_table columns names to target_table columns names. Examples: ['sell', 'list'] or {'s_sell': 't_sell', 's_list': 't_list'}
kwargsDictAny keyword arguments supported by the BaseOperator is supported (e.g queue, owner).
Documentation
Append the source table rows into a destination table.