Man pages for moj-analytical-services/dbtools
Uses R wrapper function to send queries to athena.
| create_temp_table | Create a temporary table |
| dbtools | dbtools: A package for accessing AWS Athena from the... |
| delete_database_and_data | Deletes both an Athena database and the underlying data on... |
| delete_partitions_and_data | Deletes partitions and the underlying data on S3 from an... |
| delete_table_and_data | Deletes both a table from an Athena database and the... |
| describe_table | Show the list of columns, including partition columns:... |
| get_query_columns_types | Get the data type of all columns queried. |
| get_query_execution | Fetch query execution details. |
| get_sql_from_file | Read in an SQL file and inject arguments with Jinja (if given... |
| pipe | Pipe operator |
| read_sql | Uses boto3 (in python) to send an sql query to athena and... |
| read_sql_query | Send an SQL query to Athena and receive a dataframe. |
| render_sql_template | Takes an SQL query and injects arguments with Jinja. |
| repair_table | Run the Hive's metastore consistency check: 'MSCK REPAIR... |
| show_create_table | Generate the query that created a table: 'SHOW CREATE TABLE... |
| start_query_execution | Start a SQL Query against AWS Athena |
| start_query_execution_and_wait | Calls start_query_execution followed by wait_query. |
| stop_query_execution | Stop a query execution |
| wait_query | Wait for a query to end. |
