aws athena
Amazon Athena is an interactive query service that lets you use standard SQL to analyze data directly in Amazon S3. AWS CLI reference
75 commands Its page in the AWS CLI reference
Commands
batch-get-named-queryReturns the details of a single named query or a list of up to 50 queries, which you provide as an array of query ID strings.batch-get-prepared-statementReturns the details of a single prepared statement or a list of up to 256 prepared statements for the array of prepared statement names that you provide.batch-get-query-executionReturns the details of a single query execution or a list of up to 50 query executions, which you provide as an array of query execution ID strings.cancel-capacity-reservationCancels the capacity reservation with the specified name.create-capacity-reservationCreates a capacity reservation with the specified name and number of requested data processing units.create-data-catalogCreates (registers) a data catalog with the specified name and properties.create-named-queryCreates a named query in the specified workgroup.create-notebookCreates an empty ipynb file in the specified Apache Spark enabled workgroup.create-prepared-statementCreates a prepared statement for use with SQL queries in Athena.create-presigned-notebook-urlGets an authentication token and the URL at which the notebook can be accessed.create-system-table-configurationEnables system tables for the current account.create-work-groupCreates a workgroup with the specified name.delete-capacity-reservationDeletes a cancelled capacity reservation.delete-data-catalogDeletes a data catalog.delete-named-queryDeletes the named query if you have access to the workgroup in which the query was saved.delete-notebookDeletes the specified notebook.delete-prepared-statementDeletes the prepared statement with the specified name from the specified workgroup.delete-system-table-configurationDisables system tables for the current account by deleting the account-level configuration.delete-work-groupDeletes the workgroup with the specified name.export-notebookExports the specified notebook and its metadata.get-calculation-executionDescribes a previously submitted calculation execution.get-calculation-execution-codeRetrieves the unencrypted code that was executed for the calculation.get-calculation-execution-statusGets the status of a current calculation.get-capacity-assignment-configurationGets the capacity assignment configuration for a capacity reservation, if one exists.get-capacity-reservationReturns information about the capacity reservation with the specified name.get-data-catalogReturns the specified data catalog.get-databaseReturns a database object for the specified database and data catalog.get-named-queryReturns information about a single query.get-notebook-metadataRetrieves notebook metadata for the specified notebook ID.get-prepared-statementRetrieves the prepared statement with the specified name from the specified workgroup.get-query-executionReturns information about a single execution of a query if you have access to the workgroup in which the query ran.get-query-resultsStreams the results of a single query execution specified by QueryExecutionId from the Athena query results location in Amazon S3.get-query-runtime-statisticsReturns query execution runtime statistics related to a single execution of a query if you have access to the workgroup in which the query ran.get-resource-dashboardGets the Live UI/Persistence UI for a session.get-sessionGets the full details of a previously created session, including the session status and configuration.get-session-endpointGets a connection endpoint and authentication token for a given session Id.get-session-statusGets the current status of a session.get-system-table-configurationReturns the account-level system tables configuration.get-table-metadataReturns table metadata for the specified catalog, database, and table.get-work-groupReturns information about the workgroup with the specified name.import-notebookImports a single ipynb file to a Spark enabled workgroup.list-application-dpu-sizesReturns the supported DPU sizes for the supported application runtimes (for example, Athena notebook version 1).list-calculation-executionsLists the calculations that have been submitted to a session in descending order.list-capacity-reservationsLists the capacity reservations for the current account.list-data-catalogsLists the data catalogs in the current Amazon Web Services account.list-databasesLists the databases in the specified data catalog.list-engine-versionsReturns a list of engine versions that are available to choose from, including the Auto option.list-executorsLists, in descending order, the executors that joined a session.list-named-queriesProvides a list of available query IDs only for queries saved in the specified workgroup.list-notebook-metadataDisplays the notebook files for the specified workgroup in paginated format.list-notebook-sessionsLists, in descending order, the sessions that have been created in a notebook that are in an active state like CREATING, CREATED, IDLE or BUSY.list-prepared-statementsLists the prepared statements in the specified workgroup.list-query-executionsProvides a list of available query execution IDs for the queries in the specified workgroup.list-sessionsLists the sessions in a workgroup that are in an active state like CREATING, CREATED, IDLE, or BUSY.list-system-table-statusesLists the system tables that the account-level configuration activates, along with whether each is currently enabled.list-table-metadataLists the metadata for the tables in the specified data catalog database.list-tags-for-resourceLists the tags associated with an Athena resource.list-work-groupsLists available workgroups for the account.put-capacity-assignment-configurationPuts a new capacity assignment configuration for a specified capacity reservation.start-calculation-executionSubmits calculations for execution within a session.start-query-executionRuns the SQL query statements contained in the Query.start-sessionCreates a session for running calculations within a workgroup.stop-calculation-executionRequests the cancellation of a calculation.stop-query-executionStops a query execution.tag-resourceAdds one or more tags to an Athena resource.terminate-sessionTerminates an active session.untag-resourceRemoves one or more tags from an Athena resource.update-capacity-reservationUpdates the number of requested data processing units for the capacity reservation with the specified name.update-data-catalogUpdates the data catalog that has the specified name.update-named-queryUpdates a NamedQuery object.update-notebookUpdates the contents of a Spark notebook.update-notebook-metadataUpdates the metadata for a notebook.update-prepared-statementUpdates a prepared statement.update-system-table-configurationUpdates the account-level system tables configuration.update-work-groupUpdates the workgroup with the specified name.