All functions

check_attr()

Check if object has an attribute

db_append()

Append rows into a database table

db_close()

Close a database connection

db_config()

Load DB connection parameters

db_config_encrypt_secret()

Encrypt a secret via KMS and prints the base64-encoded cipher-text to the console

db_config_invalidate_cache()

Invalidates the cached secret storage

db_connect()

Connect to a database using YAML configs

db_insert()

Insert rows into a database table

db_query()

Execute an SQL query in a database

db_refresh()

Refresh SQL query

redshift_insert_via_copy_from_s3()

Dumps a data frame to disk, copies to S3 and runs COPY FROM on Redshift

sql_chunk()

Look up common SQL chunks from YAML definitions to be reused in SQL queries

sql_chunk_files()

List or update the list of SQL chunk files to be used in sql_chunk

sql_chunks()

Look up all SQL chunks from YAML definitions

write_jsonlines()

Writes each row of a data frame as JSON into a file separated by line breaks as per http://jsonlines.org