Modules are Python callables available from this provider package.
A metadata representation of database table within the Astro ecosystem that will not be persisted after corresponding operations are complete.
Execute SQL that is not expected to return data like DDL or DML operations.
Export a database table as a CSV or Parquet file to local storage, Amazon S3, or Google Cloud Storage.
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…
Append the results of a source table onto a target table. This function assumes there are no conflicts between the schemas of both tables.
Convert a Table object into a Pandas DataFrame or persist a DataFrame result to a database table.
A metadata representation of an existing or to-be-created database table within the Astro ecosystem.
Validate the result from a SQL which performs an aggregation matches an expected value or falls within a provided range.
Load CSV or Parquet files from local storage, Amazon S3, or Google Cloud Storage into a SQL database.
Perform a TRUNCATE operation on a given table.
Execute a SELECT SQL statement contained in a file. Data returned from this SQL is inserted into a temporary table which can used by other downstream …
Execute an explicit, SELECT SQL statement. Data returned from this SQL is inserted into a temporary table which can used by other downstream tasks.