Astro SDK

append

Append the results of a source table onto a target table. This function assumes there are no conflicts between the schemas of both tables.

dataframe

Convert a Table object into a Pandas DataFrame or persist a DataFrame result to a database table.

export_file

Export a database table as a CSV or Parquet file to local storage, Amazon S3, or Google Cloud Storage.

load_file

Load CSV or Parquet files from local storage, Amazon S3, or Google Cloud Storage into a SQL database.

merge

Merge data into an existing table in situations where there may be conflicts. This function adds data to a table with either an "update" or "ignore" s…

run_raw_sql

Execute SQL that is not expected to return data like DDL or DML operations.

transform

Execute an explicit, SELECT SQL statement. Data returned from this SQL is inserted into a temporary table which can used by other downstream tasks.

truncate

Perform a TRUNCATE operation on a given table.