athenacli | CLI tool for AWS Athena service | Command Line Interface library

by dbcli Python Version: 1.6.8 License: BSD-3-Clause

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | athenacli Summary

athenacli is a Python library typically used in Utilities, Command Line Interface, Visual Studio Code applications. athenacli has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can install using 'pip install athenacli' or download it from GitHub, PyPI.

AthenaCLI is a command line interface (CLI) for the Athena service that can do auto-completion and syntax highlighting, and is a proud member of the dbcli community.

Support

Quality

Security

License

Reuse

Support

athenacli has a low active ecosystem.

It has 155 star(s) with 22 fork(s). There are 6 watchers for this library.

It had no major release in the last 12 months.

There are 5 open issues and 25 have been closed. On average issues are closed in 141 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of athenacli is 1.6.8

Quality

athenacli has 0 bugs and 0 code smells.

Security

athenacli has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

athenacli code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

athenacli is licensed under the BSD-3-Clause License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

athenacli releases are not available. You will need to build from source code and install.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

Installation instructions, examples and code snippets are available.

athenacli saves you 1199 person hours of effort in developing the same functionality from scratch.

It has 2702 lines of code, 240 functions and 39 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed athenacli and discovered the below as its top functions. This is intended to give you an instant insight into athenacli implemented functionality, and help decide if they suit your requirements.

Watch a query
Execute a special command
Parse special command
Show help for a given keyword
Execute athenacli
Write default config file
Make a directory
Run the CLI
Yield SQL statements
Extract tables from an SQL statement
Extend function metadata
Get the version number
List databases
Set the tee file
Change the prompt format
Set pager
Return a list of possible column matches
Get keywords matching the given suggestion
Extract tables from a SQL statement
List all tables
Read configuration files
Read config file
Background refresh function
Execute favorite query
Execute a file query
Return a pygments style from the given name
Return a list of user - defined function matches

Get all kandi verified functions for this library.

athenacli Key Features

No Key Features are available at this moment for athenacli.

athenacli Examples and Code Snippets

No Code Snippets are available at this moment for athenacli.

Community Discussions

Trending Discussions on athenacli

AWS CLI Athena,Python - pass query programmatically

QUESTION

AWS CLI Athena,Python - pass query programmatically

Asked 2018-Dec-19 at 16:15

I am trying to run a set of Athena SQL statements through the AWS CLI commands and I need to know the following

The set of SQL queries are in a file and I need to sequentially iterate the --query-string in the following CLI command for each query through a python script

I can use FOR loop to get the sql commands from the file but I don't know how to parameterize it in AWS CLI command.

AWS CLI Command ...

ANSWER

Answered 2018-Dec-19 at 16:15

#!/bin/bash
while IFS='' read -r sql || [[ -n "$sql" ]]; do
    aws athena start-query-execution \
    --query-string "$sql" \
    --query-execution-context Database=test45 \
    --result-configuration OutputLocation=s3://test/ \
    --output text
done < "$1"

Source https://stackoverflow.com/questions/44296510

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install athenacli

If you already know how to install python packages, then you can simply do:.
Homebrew users can install by:. If you don't know how to install python packages, please check the Install page for more options (e.g docker).

Support

If you're interested in contributing to this project, first of all I would like to extend my heartfelt gratitude. I've written a small doc to describe how to get this running in a development setup. Please feel free to reach out to me if you need help. My email: zhuzhaolong0 AT gmail com.

Find more information at: