create_named_query: Create a named query.

Description Usage Arguments References Examples

Description

Create a named query.

Usage

1
2
3
4
create_named_query(name, description, query, database,
  client_request_token = uuid::UUIDgenerate(), encryption_option = NULL,
  kms_key = NULL, aws_access_key_id = NULL, aws_secret_access_key = NULL,
  aws_session_token = NULL, region_name = NULL, profile_name = NULL)

Arguments

name

plain language name for the query

description

brief explanation of the query

query

text of the query itself. In other words, all query statements

database

database to which the query belongs

client_request_token

unique case-sensitive string used to ensure the request to create the query is idempotent (executes only once). If another CreateNamedQuery request is received, the same response is returned and another query is not created. If a parameter has changed, for example, the query , an error is returned. This is auto-generated-for-you.

aws_access_key_id

AWS access key id

aws_secret_access_key

AWS secret access key

aws_session_token

AWS session token

region_name

region name

profile_name

profile name

References

https://boto3.readthedocs.io/en/latest/reference/services/athena.html#Athena.Client.create_named_query

Examples

1
2
3
4
5
6
7
8
9
## Not run: 
create_named_query(
  name = "elb100",
  description = "100 rows from elb_logs",
  query = "SELECT * FROM elb_logs LIMIT 100",
  database = "sampledb"
)

## End(Not run)

hrbrmstr/roto.athena documentation built on May 29, 2019, 11:42 a.m.