Table of Contents
A low-level client representing AWS Lake Formation
Defines the public endpoint for the Lake Formation service.
import boto3
client = boto3.client('lakeformation')
These are the available methods:
Attaches one or more LF-tags to an existing resource.
See also: AWS API Documentation
Request Syntax
response = client.add_lf_tags_to_resource(
CatalogId='string',
Resource={
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
LFTags=[
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
)
[REQUIRED]
The database, table, or column resource to which to attach an LF-tag.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
[REQUIRED]
The LF-tags to attach to the resource.
A structure containing an LF-tag key-value pair.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
dict
Response Syntax
{
'Failures': [
{
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'Error': {
'ErrorCode': 'string',
'ErrorMessage': 'string'
}
},
]
}
Response Structure
(dict) --
Failures (list) --
A list of failures to tag the resource.
(dict) --
A structure containing an error related to a TagResource or UnTagResource operation.
LFTag (dict) --
The key-name of the LF-tag.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Error (dict) --
An error that occurred with the attachment or detachment of the LF-tag.
ErrorCode (string) --
The code associated with this error.
ErrorMessage (string) --
A message describing the error.
Exceptions
Batch operation to grant permissions to the principal.
See also: AWS API Documentation
Request Syntax
response = client.batch_grant_permissions(
CatalogId='string',
Entries=[
{
'Id': 'string',
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Resource': {
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'PermissionsWithGrantOption': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
]
)
[REQUIRED]
A list of up to 20 entries for resource permissions to be granted by batch operation to the principal.
A permission to a resource granted by batch operation to the principal.
A unique identifier for the batch permissions request entry.
The principal to be granted a permission.
An identifier for the Lake Formation principal.
The resource to which the principal is to be granted a permission.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
The permissions to be granted.
Indicates if the option to pass permissions is granted.
dict
Response Syntax
{
'Failures': [
{
'RequestEntry': {
'Id': 'string',
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Resource': {
'Catalog': {},
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'PermissionsWithGrantOption': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
'Error': {
'ErrorCode': 'string',
'ErrorMessage': 'string'
}
},
]
}
Response Structure
(dict) --
Failures (list) --
A list of failures to grant permissions to the resources.
(dict) --
A list of failures when performing a batch grant or batch revoke operation.
RequestEntry (dict) --
An identifier for an entry of the batch request.
Id (string) --
A unique identifier for the batch permissions request entry.
Principal (dict) --
The principal to be granted a permission.
DataLakePrincipalIdentifier (string) --
An identifier for the Lake Formation principal.
Resource (dict) --
The resource to which the principal is to be granted a permission.
Catalog (dict) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
Database (dict) --
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
Name (string) --
The name of the database resource. Unique to the Data Catalog.
Table (dict) --
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table.
TableWildcard (dict) --
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
TableWithColumns (dict) --
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
ColumnNames (list) --
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
ColumnWildcard (dict) --
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
ExcludedColumnNames (list) --
Excludes column names. Any column with this name will be excluded.
DataLocation (dict) --
The location of an Amazon S3 path where permissions are granted or revoked.
CatalogId (string) --
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
ResourceArn (string) --
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
DataCellsFilter (dict) --
A data cell filter.
TableCatalogId (string) --
The ID of the catalog to which the table belongs.
DatabaseName (string) --
A database in the Glue Data Catalog.
TableName (string) --
The name of the table.
Name (string) --
The name of the data cells filter.
LFTag (dict) --
The LF-tag key and values attached to a resource.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagPolicy (dict) --
A list of LF-tag conditions that define a resource's LF-tag policy.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
ResourceType (string) --
The resource type for which the LF-tag policy applies.
Expression (list) --
A list of LF-tag conditions that apply to the resource's LF-tag policy.
(dict) --
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Permissions (list) --
The permissions to be granted.
PermissionsWithGrantOption (list) --
Indicates if the option to pass permissions is granted.
Error (dict) --
An error message that applies to the failure of the entry.
ErrorCode (string) --
The code associated with this error.
ErrorMessage (string) --
A message describing the error.
Exceptions
Batch operation to revoke permissions from the principal.
See also: AWS API Documentation
Request Syntax
response = client.batch_revoke_permissions(
CatalogId='string',
Entries=[
{
'Id': 'string',
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Resource': {
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'PermissionsWithGrantOption': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
]
)
[REQUIRED]
A list of up to 20 entries for resource permissions to be revoked by batch operation to the principal.
A permission to a resource granted by batch operation to the principal.
A unique identifier for the batch permissions request entry.
The principal to be granted a permission.
An identifier for the Lake Formation principal.
The resource to which the principal is to be granted a permission.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
The permissions to be granted.
Indicates if the option to pass permissions is granted.
dict
Response Syntax
{
'Failures': [
{
'RequestEntry': {
'Id': 'string',
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Resource': {
'Catalog': {},
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'PermissionsWithGrantOption': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
'Error': {
'ErrorCode': 'string',
'ErrorMessage': 'string'
}
},
]
}
Response Structure
(dict) --
Failures (list) --
A list of failures to revoke permissions to the resources.
(dict) --
A list of failures when performing a batch grant or batch revoke operation.
RequestEntry (dict) --
An identifier for an entry of the batch request.
Id (string) --
A unique identifier for the batch permissions request entry.
Principal (dict) --
The principal to be granted a permission.
DataLakePrincipalIdentifier (string) --
An identifier for the Lake Formation principal.
Resource (dict) --
The resource to which the principal is to be granted a permission.
Catalog (dict) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
Database (dict) --
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
Name (string) --
The name of the database resource. Unique to the Data Catalog.
Table (dict) --
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table.
TableWildcard (dict) --
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
TableWithColumns (dict) --
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
ColumnNames (list) --
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
ColumnWildcard (dict) --
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
ExcludedColumnNames (list) --
Excludes column names. Any column with this name will be excluded.
DataLocation (dict) --
The location of an Amazon S3 path where permissions are granted or revoked.
CatalogId (string) --
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
ResourceArn (string) --
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
DataCellsFilter (dict) --
A data cell filter.
TableCatalogId (string) --
The ID of the catalog to which the table belongs.
DatabaseName (string) --
A database in the Glue Data Catalog.
TableName (string) --
The name of the table.
Name (string) --
The name of the data cells filter.
LFTag (dict) --
The LF-tag key and values attached to a resource.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagPolicy (dict) --
A list of LF-tag conditions that define a resource's LF-tag policy.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
ResourceType (string) --
The resource type for which the LF-tag policy applies.
Expression (list) --
A list of LF-tag conditions that apply to the resource's LF-tag policy.
(dict) --
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Permissions (list) --
The permissions to be granted.
PermissionsWithGrantOption (list) --
Indicates if the option to pass permissions is granted.
Error (dict) --
An error message that applies to the failure of the entry.
ErrorCode (string) --
The code associated with this error.
ErrorMessage (string) --
A message describing the error.
Exceptions
Check if an operation can be paginated.
Attempts to cancel the specified transaction. Returns an exception if the transaction was previously committed.
See also: AWS API Documentation
Request Syntax
response = client.cancel_transaction(
TransactionId='string'
)
[REQUIRED]
The transaction to cancel.
{}
Response Structure
Exceptions
Attempts to commit the specified transaction. Returns an exception if the transaction was previously aborted. This API action is idempotent if called multiple times for the same transaction.
See also: AWS API Documentation
Request Syntax
response = client.commit_transaction(
TransactionId='string'
)
[REQUIRED]
The transaction to commit.
{
'TransactionStatus': 'ACTIVE'|'COMMITTED'|'ABORTED'|'COMMIT_IN_PROGRESS'
}
Response Structure
The status of the transaction.
Exceptions
Creates a data cell filter to allow one to grant access to certain columns on certain rows.
See also: AWS API Documentation
Request Syntax
response = client.create_data_cells_filter(
TableData={
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string',
'RowFilter': {
'FilterExpression': 'string',
'AllRowsWildcard': {}
},
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
}
)
[REQUIRED]
A DataCellsFilter structure containing information about the data cells filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
A table in the database.
The name given by the user to the data filter cell.
A PartiQL predicate.
A filter expression.
A wildcard for all rows.
A list of column names.
A wildcard with exclusions.
Excludes column names. Any column with this name will be excluded.
{}
Response Structure
Exceptions
Creates an LF-tag with the specified name and values.
See also: AWS API Documentation
Request Syntax
response = client.create_lf_tag(
CatalogId='string',
TagKey='string',
TagValues=[
'string',
]
)
[REQUIRED]
The key-name for the LF-tag.
[REQUIRED]
A list of possible values an attribute can take.
dict
Response Syntax
{}
Response Structure
Exceptions
Deletes a data cell filter.
See also: AWS API Documentation
Request Syntax
response = client.delete_data_cells_filter(
TableCatalogId='string',
DatabaseName='string',
TableName='string',
Name='string'
)
dict
Response Syntax
{}
Response Structure
Exceptions
Deletes the specified LF-tag key name. If the attribute key does not exist or the LF-tag does not exist, then the operation will not do anything. If the attribute key exists, then the operation checks if any resources are tagged with this attribute key, if yes, the API throws a 400 Exception with the message "Delete not allowed" as the LF-tag key is still attached with resources. You can consider untagging resources with this LF-tag key.
See also: AWS API Documentation
Request Syntax
response = client.delete_lf_tag(
CatalogId='string',
TagKey='string'
)
[REQUIRED]
The key-name for the LF-tag to delete.
dict
Response Syntax
{}
Response Structure
Exceptions
For a specific governed table, provides a list of Amazon S3 objects that will be written during the current transaction and that can be automatically deleted if the transaction is canceled. Without this call, no Amazon S3 objects are automatically deleted when a transaction cancels.
The Glue ETL library function write_dynamic_frame.from_catalog() includes an option to automatically call DeleteObjectsOnCancel before writes. For more information, see Rolling Back Amazon S3 Writes .
See also: AWS API Documentation
Request Syntax
response = client.delete_objects_on_cancel(
CatalogId='string',
DatabaseName='string',
TableName='string',
TransactionId='string',
Objects=[
{
'Uri': 'string',
'ETag': 'string'
},
]
)
[REQUIRED]
The database that contains the governed table.
[REQUIRED]
The name of the governed table.
[REQUIRED]
ID of the transaction that the writes occur in.
[REQUIRED]
A list of VirtualObject structures, which indicates the Amazon S3 objects to be deleted if the transaction cancels.
An object that defines an Amazon S3 object to be deleted if a transaction cancels, provided that VirtualPut was called before writing the object.
The path to the Amazon S3 object. Must start with s3://
The ETag of the Amazon S3 object.
dict
Response Syntax
{}
Response Structure
Exceptions
Deregisters the resource as managed by the Data Catalog.
When you deregister a path, Lake Formation removes the path from the inline policy attached to your service-linked role.
See also: AWS API Documentation
Request Syntax
response = client.deregister_resource(
ResourceArn='string'
)
[REQUIRED]
The Amazon Resource Name (ARN) of the resource that you want to deregister.
{}
Response Structure
Exceptions
Retrieves the current data access role for the given resource registered in Lake Formation.
See also: AWS API Documentation
Request Syntax
response = client.describe_resource(
ResourceArn='string'
)
[REQUIRED]
The resource ARN.
{
'ResourceInfo': {
'ResourceArn': 'string',
'RoleArn': 'string',
'LastModified': datetime(2015, 1, 1)
}
}
Response Structure
A structure containing information about an Lake Formation resource.
The Amazon Resource Name (ARN) of the resource.
The IAM role that registered a resource.
The date and time the resource was last modified.
Exceptions
Returns the details of a single transaction.
See also: AWS API Documentation
Request Syntax
response = client.describe_transaction(
TransactionId='string'
)
[REQUIRED]
The transaction for which to return status.
{
'TransactionDescription': {
'TransactionId': 'string',
'TransactionStatus': 'ACTIVE'|'COMMITTED'|'ABORTED'|'COMMIT_IN_PROGRESS',
'TransactionStartTime': datetime(2015, 1, 1),
'TransactionEndTime': datetime(2015, 1, 1)
}
}
Response Structure
Returns a TransactionDescription object containing information about the transaction.
The ID of the transaction.
A status of ACTIVE, COMMITTED, or ABORTED.
The time when the transaction started.
The time when the transaction committed or aborted, if it is not currently active.
Exceptions
Indicates to the service that the specified transaction is still active and should not be treated as idle and aborted.
Write transactions that remain idle for a long period are automatically aborted unless explicitly extended.
See also: AWS API Documentation
Request Syntax
response = client.extend_transaction(
TransactionId='string'
)
{}
Response Structure
Exceptions
Retrieves the list of the data lake administrators of a Lake Formation-managed data lake.
See also: AWS API Documentation
Request Syntax
response = client.get_data_lake_settings(
CatalogId='string'
)
{
'DataLakeSettings': {
'DataLakeAdmins': [
{
'DataLakePrincipalIdentifier': 'string'
},
],
'CreateDatabaseDefaultPermissions': [
{
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
],
'CreateTableDefaultPermissions': [
{
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
],
'TrustedResourceOwners': [
'string',
]
}
}
Response Structure
A structure representing a list of Lake Formation principals designated as data lake administrators.
A list of Lake Formation principals. Supported principals are IAM users or IAM roles.
The AWS Lake Formation principal. Supported principals are IAM users or IAM roles.
An identifier for the Lake Formation principal.
Specifies whether access control on newly created database is managed by Lake Formation permissions or exclusively by IAM permissions. You can override this default setting when you create a database.
A null value indicates access control by Lake Formation permissions. A value that assigns ALL to IAM_ALLOWED_PRINCIPALS indicates access control by IAM permissions. This is referred to as the setting "Use only IAM access control," and is for backward compatibility with the Glue permission model implemented by IAM permissions.
The only permitted values are an empty array or an array that contains a single JSON object that grants ALL to IAM_ALLOWED_PRINCIPALS.
For more information, see Changing the Default Security Settings for Your Data Lake .
Permissions granted to a principal.
The principal who is granted permissions.
An identifier for the Lake Formation principal.
The permissions that are granted to the principal.
Specifies whether access control on newly created table is managed by Lake Formation permissions or exclusively by IAM permissions.
A null value indicates access control by Lake Formation permissions. A value that assigns ALL to IAM_ALLOWED_PRINCIPALS indicates access control by IAM permissions. This is referred to as the setting "Use only IAM access control," and is for backward compatibility with the Glue permission model implemented by IAM permissions.
The only permitted values are an empty array or an array that contains a single JSON object that grants ALL to IAM_ALLOWED_PRINCIPALS.
For more information, see Changing the Default Security Settings for Your Data Lake .
Permissions granted to a principal.
The principal who is granted permissions.
An identifier for the Lake Formation principal.
The permissions that are granted to the principal.
A list of the resource-owning account IDs that the caller's account can use to share their user access details (user ARNs). The user ARNs can be logged in the resource owner's CloudTrail log.
You may want to specify this property when you are in a high-trust boundary, such as the same team or company.
Exceptions
Returns the Lake Formation permissions for a specified table or database resource located at a path in Amazon S3. GetEffectivePermissionsForPath will not return databases and tables if the catalog is encrypted.
See also: AWS API Documentation
Request Syntax
response = client.get_effective_permissions_for_path(
CatalogId='string',
ResourceArn='string',
NextToken='string',
MaxResults=123
)
[REQUIRED]
The Amazon Resource Name (ARN) of the resource for which you want to get permissions.
dict
Response Syntax
{
'Permissions': [
{
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Resource': {
'Catalog': {},
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'PermissionsWithGrantOption': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'AdditionalDetails': {
'ResourceShare': [
'string',
]
}
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
Permissions (list) --
A list of the permissions for the specified table or database resource located at the path in Amazon S3.
(dict) --
The permissions granted or revoked on a resource.
Principal (dict) --
The Data Lake principal to be granted or revoked permissions.
DataLakePrincipalIdentifier (string) --
An identifier for the Lake Formation principal.
Resource (dict) --
The resource where permissions are to be granted or revoked.
Catalog (dict) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
Database (dict) --
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
Name (string) --
The name of the database resource. Unique to the Data Catalog.
Table (dict) --
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table.
TableWildcard (dict) --
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
TableWithColumns (dict) --
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
ColumnNames (list) --
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
ColumnWildcard (dict) --
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
ExcludedColumnNames (list) --
Excludes column names. Any column with this name will be excluded.
DataLocation (dict) --
The location of an Amazon S3 path where permissions are granted or revoked.
CatalogId (string) --
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
ResourceArn (string) --
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
DataCellsFilter (dict) --
A data cell filter.
TableCatalogId (string) --
The ID of the catalog to which the table belongs.
DatabaseName (string) --
A database in the Glue Data Catalog.
TableName (string) --
The name of the table.
Name (string) --
The name of the data cells filter.
LFTag (dict) --
The LF-tag key and values attached to a resource.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagPolicy (dict) --
A list of LF-tag conditions that define a resource's LF-tag policy.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
ResourceType (string) --
The resource type for which the LF-tag policy applies.
Expression (list) --
A list of LF-tag conditions that apply to the resource's LF-tag policy.
(dict) --
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Permissions (list) --
The permissions to be granted or revoked on the resource.
PermissionsWithGrantOption (list) --
Indicates whether to grant the ability to grant permissions (as a subset of permissions granted).
AdditionalDetails (dict) --
This attribute can be used to return any additional details of PrincipalResourcePermissions . Currently returns only as a RAM resource share ARN.
ResourceShare (list) --
A resource share ARN for a catalog resource shared through RAM.
NextToken (string) --
A continuation token, if this is not the first call to retrieve this list.
Exceptions
Returns an LF-tag definition.
See also: AWS API Documentation
Request Syntax
response = client.get_lf_tag(
CatalogId='string',
TagKey='string'
)
[REQUIRED]
The key-name for the LF-tag.
dict
Response Syntax
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
}
Response Structure
(dict) --
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Exceptions
Create a paginator for an operation.
Returns the state of a query previously submitted. Clients are expected to poll GetQueryState to monitor the current state of the planning before retrieving the work units. A query state is only visible to the principal that made the initial call to StartQueryPlanning .
See also: AWS API Documentation
Request Syntax
response = client.get_query_state(
QueryId='string'
)
[REQUIRED]
The ID of the plan query operation.
{
'Error': 'string',
'State': 'PENDING'|'WORKUNITS_AVAILABLE'|'ERROR'|'FINISHED'|'EXPIRED'
}
Response Structure
A structure for the output.
An error message when the operation fails.
The state of a query previously submitted. The possible states are:
Exceptions
Retrieves statistics on the planning and execution of a query.
See also: AWS API Documentation
Request Syntax
response = client.get_query_statistics(
QueryId='string'
)
[REQUIRED]
The ID of the plan query operation.
{
'ExecutionStatistics': {
'AverageExecutionTimeMillis': 123,
'DataScannedBytes': 123,
'WorkUnitsExecutedCount': 123
},
'PlanningStatistics': {
'EstimatedDataToScanBytes': 123,
'PlanningTimeMillis': 123,
'QueueTimeMillis': 123,
'WorkUnitsGeneratedCount': 123
},
'QuerySubmissionTime': datetime(2015, 1, 1)
}
Response Structure
An ExecutionStatistics structure containing execution statistics.
The average time the request took to be executed.
The amount of data that was scanned in bytes.
The number of work units executed.
A PlanningStatistics structure containing query planning statistics.
An estimate of the data that was scanned in bytes.
The time that it took to process the request.
The time the request was in queue to be processed.
The number of work units generated.
The time that the query was submitted.
Exceptions
Returns the LF-tags applied to a resource.
See also: AWS API Documentation
Request Syntax
response = client.get_resource_lf_tags(
CatalogId='string',
Resource={
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
ShowAssignedLFTags=True|False
)
[REQUIRED]
The database, table, or column resource for which you want to return LF-tags.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
dict
Response Syntax
{
'LFTagOnDatabase': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'LFTagsOnTable': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'LFTagsOnColumns': [
{
'Name': 'string',
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
},
]
}
Response Structure
(dict) --
LFTagOnDatabase (list) --
A list of LF-tags applied to a database resource.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagsOnTable (list) --
A list of LF-tags applied to a table resource.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagsOnColumns (list) --
A list of LF-tags applied to a column resource.
(dict) --
A structure containing the name of a column resource and the LF-tags attached to it.
Name (string) --
The name of a column resource.
LFTags (list) --
The LF-tags attached to a column resource.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Exceptions
Returns the set of Amazon S3 objects that make up the specified governed table. A transaction ID or timestamp can be specified for time-travel queries.
See also: AWS API Documentation
Request Syntax
response = client.get_table_objects(
CatalogId='string',
DatabaseName='string',
TableName='string',
TransactionId='string',
QueryAsOfTime=datetime(2015, 1, 1),
PartitionPredicate='string',
MaxResults=123,
NextToken='string'
)
[REQUIRED]
The database containing the governed table.
[REQUIRED]
The governed table for which to retrieve objects.
A predicate to filter the objects returned based on the partition keys defined in the governed table.
dict
Response Syntax
{
'Objects': [
{
'PartitionValues': [
'string',
],
'Objects': [
{
'Uri': 'string',
'ETag': 'string',
'Size': 123
},
]
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
Objects (list) --
A list of objects organized by partition keys.
(dict) --
A structure containing a list of partition values and table objects.
PartitionValues (list) --
A list of partition values.
Objects (list) --
A list of table objects
(dict) --
Specifies the details of a governed table.
Uri (string) --
The Amazon S3 location of the object.
ETag (string) --
The Amazon S3 ETag of the object. Returned by GetTableObjects for validation and used to identify changes to the underlying data.
Size (integer) --
The size of the Amazon S3 object in bytes.
NextToken (string) --
A continuation token indicating whether additional data is available.
Exceptions
Returns an object that can wait for some condition.
Returns the work units resulting from the query. Work units can be executed in any order and in parallel.
See also: AWS API Documentation
Request Syntax
response = client.get_work_unit_results(
QueryId='string',
WorkUnitId=123,
WorkUnitToken='string'
)
[REQUIRED]
The ID of the plan query operation for which to get results.
[REQUIRED]
The work unit ID for which to get results. Value generated by enumerating WorkUnitIdMin to WorkUnitIdMax (inclusive) from the WorkUnitRange in the output of GetWorkUnits .
[REQUIRED]
A work token used to query the execution service. Token output from GetWorkUnits .
dict
Response Syntax
{
'ResultStream': StreamingBody()
}
Response Structure
(dict) --
A structure for the output.
ResultStream (StreamingBody) --
Rows returned from the GetWorkUnitResults operation as a stream of Apache Arrow v1.0 messages.
Exceptions
Retrieves the work units generated by the StartQueryPlanning operation.
See also: AWS API Documentation
Request Syntax
response = client.get_work_units(
NextToken='string',
PageSize=123,
QueryId='string'
)
[REQUIRED]
The ID of the plan query operation.
dict
Response Syntax
{
'NextToken': 'string',
'QueryId': 'string',
'WorkUnitRanges': [
{
'WorkUnitIdMax': 123,
'WorkUnitIdMin': 123,
'WorkUnitToken': 'string'
},
]
}
Response Structure
(dict) --
A structure for the output.
NextToken (string) --
A continuation token for paginating the returned list of tokens, returned if the current segment of the list is not the last.
QueryId (string) --
The ID of the plan query operation.
WorkUnitRanges (list) --
A WorkUnitRangeList object that specifies the valid range of work unit IDs for querying the execution service.
(dict) --
Defines the valid range of work unit IDs for querying the execution service.
WorkUnitIdMax (integer) --
Defines the maximum work unit ID in the range. The maximum value is inclusive.
WorkUnitIdMin (integer) --
Defines the minimum work unit ID in the range.
WorkUnitToken (string) --
A work token used to query the execution service.
Exceptions
Grants permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3.
For information about permissions, see Security and Access Control to Metadata and Data .
See also: AWS API Documentation
Request Syntax
response = client.grant_permissions(
CatalogId='string',
Principal={
'DataLakePrincipalIdentifier': 'string'
},
Resource={
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
Permissions=[
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
PermissionsWithGrantOption=[
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
)
[REQUIRED]
The principal to be granted the permissions on the resource. Supported principals are IAM users or IAM roles, and they are defined by their principal type and their ARN.
Note that if you define a resource with a particular ARN, then later delete, and recreate a resource with that same ARN, the resource maintains the permissions already granted.
An identifier for the Lake Formation principal.
[REQUIRED]
The resource to which permissions are to be granted. Resources in Lake Formation are the Data Catalog, databases, and tables.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
[REQUIRED]
The permissions granted to the principal on the resource. Lake Formation defines privileges to grant and revoke access to metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3. Lake Formation requires that each principal be authorized to perform a specific task on Lake Formation resources.
Indicates a list of the granted permissions that the principal may pass to other users. These permissions may only be a subset of the permissions granted in the Privileges .
dict
Response Syntax
{}
Response Structure
Exceptions
Lists all the data cell filters on a table.
See also: AWS API Documentation
Request Syntax
response = client.list_data_cells_filter(
Table={
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
NextToken='string',
MaxResults=123
)
A table in the Glue Data Catalog.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
dict
Response Syntax
{
'DataCellsFilters': [
{
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string',
'RowFilter': {
'FilterExpression': 'string',
'AllRowsWildcard': {}
},
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
DataCellsFilters (list) --
A list of DataCellFilter structures.
(dict) --
A structure that describes certain columns on certain rows.
TableCatalogId (string) --
The ID of the catalog to which the table belongs.
DatabaseName (string) --
A database in the Glue Data Catalog.
TableName (string) --
A table in the database.
Name (string) --
The name given by the user to the data filter cell.
RowFilter (dict) --
A PartiQL predicate.
FilterExpression (string) --
A filter expression.
AllRowsWildcard (dict) --
A wildcard for all rows.
ColumnNames (list) --
A list of column names.
ColumnWildcard (dict) --
A wildcard with exclusions.
ExcludedColumnNames (list) --
Excludes column names. Any column with this name will be excluded.
NextToken (string) --
A continuation token, if not all requested data cell filters have been returned.
Exceptions
Lists LF-tags that the requester has permission to view.
See also: AWS API Documentation
Request Syntax
response = client.list_lf_tags(
CatalogId='string',
ResourceShareType='FOREIGN'|'ALL',
MaxResults=123,
NextToken='string'
)
dict
Response Syntax
{
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
LFTags (list) --
A list of LF-tags that the requested has permission to view.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
NextToken (string) --
A continuation token, present if the current list segment is not the last.
Exceptions
Returns a list of the principal permissions on the resource, filtered by the permissions of the caller. For example, if you are granted an ALTER permission, you are able to see only the principal permissions for ALTER.
This operation returns only those permissions that have been explicitly granted.
For information about permissions, see Security and Access Control to Metadata and Data .
See also: AWS API Documentation
Request Syntax
response = client.list_permissions(
CatalogId='string',
Principal={
'DataLakePrincipalIdentifier': 'string'
},
ResourceType='CATALOG'|'DATABASE'|'TABLE'|'DATA_LOCATION'|'LF_TAG'|'LF_TAG_POLICY'|'LF_TAG_POLICY_DATABASE'|'LF_TAG_POLICY_TABLE',
Resource={
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
NextToken='string',
MaxResults=123,
IncludeRelated='string'
)
Specifies a principal to filter the permissions returned.
An identifier for the Lake Formation principal.
A resource where you will get a list of the principal permissions.
This operation does not support getting privileges on a table with columns. Instead, call this operation on the table, and the operation returns the table and the table w columns.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
dict
Response Syntax
{
'PrincipalResourcePermissions': [
{
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Resource': {
'Catalog': {},
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'PermissionsWithGrantOption': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
'AdditionalDetails': {
'ResourceShare': [
'string',
]
}
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
PrincipalResourcePermissions (list) --
A list of principals and their permissions on the resource for the specified principal and resource types.
(dict) --
The permissions granted or revoked on a resource.
Principal (dict) --
The Data Lake principal to be granted or revoked permissions.
DataLakePrincipalIdentifier (string) --
An identifier for the Lake Formation principal.
Resource (dict) --
The resource where permissions are to be granted or revoked.
Catalog (dict) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
Database (dict) --
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
Name (string) --
The name of the database resource. Unique to the Data Catalog.
Table (dict) --
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table.
TableWildcard (dict) --
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
TableWithColumns (dict) --
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
ColumnNames (list) --
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
ColumnWildcard (dict) --
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
ExcludedColumnNames (list) --
Excludes column names. Any column with this name will be excluded.
DataLocation (dict) --
The location of an Amazon S3 path where permissions are granted or revoked.
CatalogId (string) --
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
ResourceArn (string) --
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
DataCellsFilter (dict) --
A data cell filter.
TableCatalogId (string) --
The ID of the catalog to which the table belongs.
DatabaseName (string) --
A database in the Glue Data Catalog.
TableName (string) --
The name of the table.
Name (string) --
The name of the data cells filter.
LFTag (dict) --
The LF-tag key and values attached to a resource.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagPolicy (dict) --
A list of LF-tag conditions that define a resource's LF-tag policy.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
ResourceType (string) --
The resource type for which the LF-tag policy applies.
Expression (list) --
A list of LF-tag conditions that apply to the resource's LF-tag policy.
(dict) --
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Permissions (list) --
The permissions to be granted or revoked on the resource.
PermissionsWithGrantOption (list) --
Indicates whether to grant the ability to grant permissions (as a subset of permissions granted).
AdditionalDetails (dict) --
This attribute can be used to return any additional details of PrincipalResourcePermissions . Currently returns only as a RAM resource share ARN.
ResourceShare (list) --
A resource share ARN for a catalog resource shared through RAM.
NextToken (string) --
A continuation token, if this is not the first call to retrieve this list.
Exceptions
Lists the resources registered to be managed by the Data Catalog.
See also: AWS API Documentation
Request Syntax
response = client.list_resources(
FilterConditionList=[
{
'Field': 'RESOURCE_ARN'|'ROLE_ARN'|'LAST_MODIFIED',
'ComparisonOperator': 'EQ'|'NE'|'LE'|'LT'|'GE'|'GT'|'CONTAINS'|'NOT_CONTAINS'|'BEGINS_WITH'|'IN'|'BETWEEN',
'StringValueList': [
'string',
]
},
],
MaxResults=123,
NextToken='string'
)
Any applicable row-level and/or column-level filtering conditions for the resources.
This structure describes the filtering of columns in a table based on a filter condition.
The field to filter in the filter condition.
The comparison operator used in the filter condition.
A string with values used in evaluating the filter condition.
dict
Response Syntax
{
'ResourceInfoList': [
{
'ResourceArn': 'string',
'RoleArn': 'string',
'LastModified': datetime(2015, 1, 1)
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
ResourceInfoList (list) --
A summary of the data lake resources.
(dict) --
A structure containing information about an Lake Formation resource.
ResourceArn (string) --
The Amazon Resource Name (ARN) of the resource.
RoleArn (string) --
The IAM role that registered a resource.
LastModified (datetime) --
The date and time the resource was last modified.
NextToken (string) --
A continuation token, if this is not the first call to retrieve these resources.
Exceptions
Returns the configuration of all storage optimizers associated with a specified table.
See also: AWS API Documentation
Request Syntax
response = client.list_table_storage_optimizers(
CatalogId='string',
DatabaseName='string',
TableName='string',
StorageOptimizerType='COMPACTION'|'GARBAGE_COLLECTION'|'ALL',
MaxResults=123,
NextToken='string'
)
[REQUIRED]
Name of the database where the table is present.
[REQUIRED]
Name of the table.
dict
Response Syntax
{
'StorageOptimizerList': [
{
'StorageOptimizerType': 'COMPACTION'|'GARBAGE_COLLECTION'|'ALL',
'Config': {
'string': 'string'
},
'ErrorMessage': 'string',
'Warnings': 'string',
'LastRunDetails': 'string'
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
StorageOptimizerList (list) --
A list of the storage optimizers associated with a table.
(dict) --
A structure describing the configuration and details of a storage optimizer.
StorageOptimizerType (string) --
The specific type of storage optimizer. The supported value is compaction .
Config (dict) --
A map of the storage optimizer configuration. Currently contains only one key-value pair: is_enabled indicates true or false for acceleration.
ErrorMessage (string) --
A message that contains information about any error (if present).
When an acceleration result has an enabled status, the error message is empty.
When an acceleration result has a disabled status, the message describes an error or simply indicates "disabled by the user".
Warnings (string) --
A message that contains information about any warnings (if present).
LastRunDetails (string) --
When an acceleration result has an enabled status, contains the details of the last job run.
NextToken (string) --
A continuation token for paginating the returned list of tokens, returned if the current segment of the list is not the last.
Exceptions
Returns metadata about transactions and their status. To prevent the response from growing indefinitely, only uncommitted transactions and those available for time-travel queries are returned.
This operation can help you identify uncommitted transactions or to get information about transactions.
See also: AWS API Documentation
Request Syntax
response = client.list_transactions(
CatalogId='string',
StatusFilter='ALL'|'COMPLETED'|'ACTIVE'|'COMMITTED'|'ABORTED',
MaxResults=123,
NextToken='string'
)
dict
Response Syntax
{
'Transactions': [
{
'TransactionId': 'string',
'TransactionStatus': 'ACTIVE'|'COMMITTED'|'ABORTED'|'COMMIT_IN_PROGRESS',
'TransactionStartTime': datetime(2015, 1, 1),
'TransactionEndTime': datetime(2015, 1, 1)
},
],
'NextToken': 'string'
}
Response Structure
(dict) --
Transactions (list) --
A list of transactions. The record for each transaction is a TransactionDescription object.
(dict) --
A structure that contains information about a transaction.
TransactionId (string) --
The ID of the transaction.
TransactionStatus (string) --
A status of ACTIVE, COMMITTED, or ABORTED.
TransactionStartTime (datetime) --
The time when the transaction started.
TransactionEndTime (datetime) --
The time when the transaction committed or aborted, if it is not currently active.
NextToken (string) --
A continuation token indicating whether additional data is available.
Exceptions
Sets the list of data lake administrators who have admin privileges on all resources managed by Lake Formation. For more information on admin privileges, see Granting Lake Formation Permissions .
This API replaces the current list of data lake admins with the new list being passed. To add an admin, fetch the current list and add the new admin to that list and pass that list in this API.
See also: AWS API Documentation
Request Syntax
response = client.put_data_lake_settings(
CatalogId='string',
DataLakeSettings={
'DataLakeAdmins': [
{
'DataLakePrincipalIdentifier': 'string'
},
],
'CreateDatabaseDefaultPermissions': [
{
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
],
'CreateTableDefaultPermissions': [
{
'Principal': {
'DataLakePrincipalIdentifier': 'string'
},
'Permissions': [
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
},
],
'TrustedResourceOwners': [
'string',
]
}
)
[REQUIRED]
A structure representing a list of Lake Formation principals designated as data lake administrators.
A list of Lake Formation principals. Supported principals are IAM users or IAM roles.
The AWS Lake Formation principal. Supported principals are IAM users or IAM roles.
An identifier for the Lake Formation principal.
Specifies whether access control on newly created database is managed by Lake Formation permissions or exclusively by IAM permissions. You can override this default setting when you create a database.
A null value indicates access control by Lake Formation permissions. A value that assigns ALL to IAM_ALLOWED_PRINCIPALS indicates access control by IAM permissions. This is referred to as the setting "Use only IAM access control," and is for backward compatibility with the Glue permission model implemented by IAM permissions.
The only permitted values are an empty array or an array that contains a single JSON object that grants ALL to IAM_ALLOWED_PRINCIPALS.
For more information, see Changing the Default Security Settings for Your Data Lake .
Permissions granted to a principal.
The principal who is granted permissions.
An identifier for the Lake Formation principal.
The permissions that are granted to the principal.
Specifies whether access control on newly created table is managed by Lake Formation permissions or exclusively by IAM permissions.
A null value indicates access control by Lake Formation permissions. A value that assigns ALL to IAM_ALLOWED_PRINCIPALS indicates access control by IAM permissions. This is referred to as the setting "Use only IAM access control," and is for backward compatibility with the Glue permission model implemented by IAM permissions.
The only permitted values are an empty array or an array that contains a single JSON object that grants ALL to IAM_ALLOWED_PRINCIPALS.
For more information, see Changing the Default Security Settings for Your Data Lake .
Permissions granted to a principal.
The principal who is granted permissions.
An identifier for the Lake Formation principal.
The permissions that are granted to the principal.
A list of the resource-owning account IDs that the caller's account can use to share their user access details (user ARNs). The user ARNs can be logged in the resource owner's CloudTrail log.
You may want to specify this property when you are in a high-trust boundary, such as the same team or company.
dict
Response Syntax
{}
Response Structure
Exceptions
Registers the resource as managed by the Data Catalog.
To add or update data, Lake Formation needs read/write access to the chosen Amazon S3 path. Choose a role that you know has permission to do this, or choose the AWSServiceRoleForLakeFormationDataAccess service-linked role. When you register the first Amazon S3 path, the service-linked role and a new inline policy are created on your behalf. Lake Formation adds the first path to the inline policy and attaches it to the service-linked role. When you register subsequent paths, Lake Formation adds the path to the existing policy.
The following request registers a new location and gives Lake Formation permission to use the service-linked role to access that location.
ResourceArn = arn:aws:s3:::my-bucket UseServiceLinkedRole = true
If UseServiceLinkedRole is not set to true, you must provide or set the RoleArn :
arn:aws:iam::12345:role/my-data-access-role
See also: AWS API Documentation
Request Syntax
response = client.register_resource(
ResourceArn='string',
UseServiceLinkedRole=True|False,
RoleArn='string'
)
[REQUIRED]
The Amazon Resource Name (ARN) of the resource that you want to register.
Designates an Identity and Access Management (IAM) service-linked role by registering this role with the Data Catalog. A service-linked role is a unique type of IAM role that is linked directly to Lake Formation.
For more information, see Using Service-Linked Roles for Lake Formation .
dict
Response Syntax
{}
Response Structure
Exceptions
Removes an LF-tag from the resource. Only database, table, or tableWithColumns resource are allowed. To tag columns, use the column inclusion list in tableWithColumns to specify column input.
See also: AWS API Documentation
Request Syntax
response = client.remove_lf_tags_from_resource(
CatalogId='string',
Resource={
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
LFTags=[
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
)
[REQUIRED]
The database, table, or column resource where you want to remove an LF-tag.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
[REQUIRED]
The LF-tags to be removed from the resource.
A structure containing an LF-tag key-value pair.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
dict
Response Syntax
{
'Failures': [
{
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'Error': {
'ErrorCode': 'string',
'ErrorMessage': 'string'
}
},
]
}
Response Structure
(dict) --
Failures (list) --
A list of failures to untag a resource.
(dict) --
A structure containing an error related to a TagResource or UnTagResource operation.
LFTag (dict) --
The key-name of the LF-tag.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Error (dict) --
An error that occurred with the attachment or detachment of the LF-tag.
ErrorCode (string) --
The code associated with this error.
ErrorMessage (string) --
A message describing the error.
Exceptions
Revokes permissions to the principal to access metadata in the Data Catalog and data organized in underlying data storage such as Amazon S3.
See also: AWS API Documentation
Request Syntax
response = client.revoke_permissions(
CatalogId='string',
Principal={
'DataLakePrincipalIdentifier': 'string'
},
Resource={
'Catalog': {}
,
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'TableWithColumns': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
'DataLocation': {
'CatalogId': 'string',
'ResourceArn': 'string'
},
'DataCellsFilter': {
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string'
},
'LFTag': {
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
'LFTagPolicy': {
'CatalogId': 'string',
'ResourceType': 'DATABASE'|'TABLE',
'Expression': [
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
}
},
Permissions=[
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
],
PermissionsWithGrantOption=[
'ALL'|'SELECT'|'ALTER'|'DROP'|'DELETE'|'INSERT'|'DESCRIBE'|'CREATE_DATABASE'|'CREATE_TABLE'|'DATA_LOCATION_ACCESS'|'CREATE_TAG'|'ALTER_TAG'|'DELETE_TAG'|'DESCRIBE_TAG'|'ASSOCIATE_TAG',
]
)
[REQUIRED]
The principal to be revoked permissions on the resource.
An identifier for the Lake Formation principal.
[REQUIRED]
The resource to which permissions are to be revoked.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The database for the resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database permissions to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database resource. Unique to the Data Catalog.
The table for the resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
The table with columns for the resource. A principal with permissions to this resource can select metadata from the columns of a table in the Data Catalog and the underlying data in Amazon S3.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table with columns resource. Unique to the Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table resource. A table is a metadata definition that represents your data. You can Grant and Revoke table privileges to a principal.
The list of column names for the table. At least one of ColumnNames or ColumnWildcard is required.
A wildcard specified by a ColumnWildcard object. At least one of ColumnNames or ColumnWildcard is required.
Excludes column names. Any column with this name will be excluded.
The location of an Amazon S3 path where permissions are granted or revoked.
The identifier for the Data Catalog where the location is registered with Lake Formation. By default, it is the account ID of the caller.
The Amazon Resource Name (ARN) that uniquely identifies the data location resource.
A data cell filter.
The ID of the catalog to which the table belongs.
A database in the Glue Data Catalog.
The name of the table.
The name of the data cells filter.
The LF-tag key and values attached to a resource.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A list of LF-tag conditions that define a resource's LF-tag policy.
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
The resource type for which the LF-tag policy applies.
A list of LF-tag conditions that apply to the resource's LF-tag policy.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
[REQUIRED]
The permissions revoked to the principal on the resource. For information about permissions, see Security and Access Control to Metadata and Data .
Indicates a list of permissions for which to revoke the grant option allowing the principal to pass permissions to other principals.
dict
Response Syntax
{}
Response Structure
Exceptions
This operation allows a search on DATABASE resources by TagCondition . This operation is used by admins who want to grant user permissions on certain TagConditions . Before making a grant, the admin can use SearchDatabasesByTags to find all resources where the given TagConditions are valid to verify whether the returned resources can be shared.
See also: AWS API Documentation
Request Syntax
response = client.search_databases_by_lf_tags(
NextToken='string',
MaxResults=123,
CatalogId='string',
Expression=[
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
)
[REQUIRED]
A list of conditions (LFTag structures) to search for in database resources.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
dict
Response Syntax
{
'NextToken': 'string',
'DatabaseList': [
{
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
},
]
}
Response Structure
(dict) --
NextToken (string) --
A continuation token, present if the current list segment is not the last.
DatabaseList (list) --
A list of databases that meet the LF-tag conditions.
(dict) --
A structure describing a database resource with LF-tags.
Database (dict) --
A database that has LF-tags attached to it.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
Name (string) --
The name of the database resource. Unique to the Data Catalog.
LFTags (list) --
A list of LF-tags attached to the database.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Exceptions
This operation allows a search on TABLE resources by LFTag s. This will be used by admins who want to grant user permissions on certain LF-tags. Before making a grant, the admin can use SearchTablesByLFTags to find all resources where the given LFTag s are valid to verify whether the returned resources can be shared.
See also: AWS API Documentation
Request Syntax
response = client.search_tables_by_lf_tags(
NextToken='string',
MaxResults=123,
CatalogId='string',
Expression=[
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
)
[REQUIRED]
A list of conditions (LFTag structures) to search for in table resources.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
dict
Response Syntax
{
'NextToken': 'string',
'TableList': [
{
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'LFTagOnDatabase': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'LFTagsOnTable': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'LFTagsOnColumns': [
{
'Name': 'string',
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
},
]
},
]
}
Response Structure
(dict) --
NextToken (string) --
A continuation token, present if the current list segment is not the last.
TableList (list) --
A list of tables that meet the LF-tag conditions.
(dict) --
A structure describing a table resource with LF-tags.
Table (dict) --
A table that has LF-tags attached to it.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table.
TableWildcard (dict) --
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
LFTagOnDatabase (list) --
A list of LF-tags attached to the database where the table resides.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagsOnTable (list) --
A list of LF-tags attached to the table.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagsOnColumns (list) --
A list of LF-tags attached to columns in the table.
(dict) --
A structure containing the name of a column resource and the LF-tags attached to it.
Name (string) --
The name of a column resource.
LFTags (list) --
The LF-tags attached to a column resource.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
Exceptions
Submits a request to process a query statement.
This operation generates work units that can be retrieved with the GetWorkUnits operation as soon as the query state is WORKUNITS_AVAILABLE or FINISHED.
See also: AWS API Documentation
Request Syntax
response = client.start_query_planning(
QueryPlanningContext={
'CatalogId': 'string',
'DatabaseName': 'string',
'QueryAsOfTime': datetime(2015, 1, 1),
'QueryParameters': {
'string': 'string'
},
'TransactionId': 'string'
},
QueryString='string'
)
[REQUIRED]
A structure containing information about the query plan.
The ID of the Data Catalog where the partition in question resides. If none is provided, the Amazon Web Services account ID is used by default.
The database containing the table.
The time as of when to read the table contents. If not set, the most recent transaction commit time will be used. Cannot be specified along with TransactionId .
A map consisting of key-value pairs.
The transaction ID at which to read the table contents. If this transaction is not committed, the read will be treated as part of that transaction and will see its writes. If this transaction has aborted, an error will be returned. If not set, defaults to the most recent committed transaction. Cannot be specified along with QueryAsOfTime .
[REQUIRED]
A PartiQL query statement used as an input to the planner service.
dict
Response Syntax
{
'QueryId': 'string'
}
Response Structure
(dict) --
A structure for the output.
QueryId (string) --
The ID of the plan query operation can be used to fetch the actual work unit descriptors that are produced as the result of the operation. The ID is also used to get the query state and as an input to the Execute operation.
Exceptions
Starts a new transaction and returns its transaction ID. Transaction IDs are opaque objects that you can use to identify a transaction.
See also: AWS API Documentation
Request Syntax
response = client.start_transaction(
TransactionType='READ_AND_WRITE'|'READ_ONLY'
)
{
'TransactionId': 'string'
}
Response Structure
An opaque identifier for the transaction.
Exceptions
Updates the list of possible values for the specified LF-tag key. If the LF-tag does not exist, the operation throws an EntityNotFoundException. The values in the delete key values will be deleted from list of possible values. If any value in the delete key values is attached to a resource, then API errors out with a 400 Exception - "Update not allowed". Untag the attribute before deleting the LF-tag key's value.
See also: AWS API Documentation
Request Syntax
response = client.update_lf_tag(
CatalogId='string',
TagKey='string',
TagValuesToDelete=[
'string',
],
TagValuesToAdd=[
'string',
]
)
[REQUIRED]
The key-name for the LF-tag for which to add or delete values.
A list of LF-tag values to delete from the LF-tag.
A list of LF-tag values to add from the LF-tag.
dict
Response Syntax
{}
Response Structure
Exceptions
Updates the data access role used for vending access to the given (registered) resource in Lake Formation.
See also: AWS API Documentation
Request Syntax
response = client.update_resource(
RoleArn='string',
ResourceArn='string'
)
[REQUIRED]
The new role to use for the given resource registered in Lake Formation.
[REQUIRED]
The resource ARN.
dict
Response Syntax
{}
Response Structure
Exceptions
Updates the manifest of Amazon S3 objects that make up the specified governed table.
See also: AWS API Documentation
Request Syntax
response = client.update_table_objects(
CatalogId='string',
DatabaseName='string',
TableName='string',
TransactionId='string',
WriteOperations=[
{
'AddObject': {
'Uri': 'string',
'ETag': 'string',
'Size': 123,
'PartitionValues': [
'string',
]
},
'DeleteObject': {
'Uri': 'string',
'ETag': 'string',
'PartitionValues': [
'string',
]
}
},
]
)
[REQUIRED]
The database containing the governed table to update.
[REQUIRED]
The governed table to update.
[REQUIRED]
The transaction at which to do the write.
[REQUIRED]
A list of WriteOperation objects that define an object to add to or delete from the manifest for a governed table.
Defines an object to add to or delete from a governed table.
A new object to add to the governed table.
The Amazon S3 location of the object.
The Amazon S3 ETag of the object. Returned by GetTableObjects for validation and used to identify changes to the underlying data.
The size of the Amazon S3 object in bytes.
A list of partition values for the object. A value must be specified for each partition key associated with the table.
The supported data types are integer, long, date(yyyy-MM-dd), timestamp(yyyy-MM-dd HH:mm:ssXXX or yyyy-MM-dd HH:mm:ss"), string and decimal.
An object to delete from the governed table.
The Amazon S3 location of the object to delete.
The Amazon S3 ETag of the object. Returned by GetTableObjects for validation and used to identify changes to the underlying data.
A list of partition values for the object. A value must be specified for each partition key associated with the governed table.
dict
Response Syntax
{}
Response Structure
Exceptions
Updates the configuration of the storage optimizers for a table.
See also: AWS API Documentation
Request Syntax
response = client.update_table_storage_optimizer(
CatalogId='string',
DatabaseName='string',
TableName='string',
StorageOptimizerConfig={
'string': {
'string': 'string'
}
}
)
[REQUIRED]
Name of the database where the table is present.
[REQUIRED]
Name of the table for which to enable the storage optimizer.
[REQUIRED]
Name of the table for which to enable the storage optimizer.
dict
Response Syntax
{
'Result': 'string'
}
Response Structure
(dict) --
Result (string) --
A response indicating the success of failure of the operation.
Exceptions
The available paginators are:
paginator = client.get_paginator('get_work_units')
Creates an iterator that will paginate through responses from LakeFormation.Client.get_work_units().
See also: AWS API Documentation
Request Syntax
response_iterator = paginator.paginate(
QueryId='string',
PaginationConfig={
'MaxItems': 123,
'PageSize': 123,
'StartingToken': 'string'
}
)
[REQUIRED]
The ID of the plan query operation.
A dictionary that provides parameters to control pagination.
The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.
The size of each page.
A token to specify where to start paginating. This is the NextToken from a previous response.
dict
Response Syntax
{
'QueryId': 'string',
'WorkUnitRanges': [
{
'WorkUnitIdMax': 123,
'WorkUnitIdMin': 123,
'WorkUnitToken': 'string'
},
]
}
Response Structure
(dict) --
A structure for the output.
QueryId (string) --
The ID of the plan query operation.
WorkUnitRanges (list) --
A WorkUnitRangeList object that specifies the valid range of work unit IDs for querying the execution service.
(dict) --
Defines the valid range of work unit IDs for querying the execution service.
WorkUnitIdMax (integer) --
Defines the maximum work unit ID in the range. The maximum value is inclusive.
WorkUnitIdMin (integer) --
Defines the minimum work unit ID in the range.
WorkUnitToken (string) --
A work token used to query the execution service.
paginator = client.get_paginator('list_data_cells_filter')
Creates an iterator that will paginate through responses from LakeFormation.Client.list_data_cells_filter().
See also: AWS API Documentation
Request Syntax
response_iterator = paginator.paginate(
Table={
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
PaginationConfig={
'MaxItems': 123,
'PageSize': 123,
'StartingToken': 'string'
}
)
A table in the Glue Data Catalog.
The identifier for the Data Catalog. By default, it is the account ID of the caller.
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
The name of the table.
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
A dictionary that provides parameters to control pagination.
The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.
The size of each page.
A token to specify where to start paginating. This is the NextToken from a previous response.
dict
Response Syntax
{
'DataCellsFilters': [
{
'TableCatalogId': 'string',
'DatabaseName': 'string',
'TableName': 'string',
'Name': 'string',
'RowFilter': {
'FilterExpression': 'string',
'AllRowsWildcard': {}
},
'ColumnNames': [
'string',
],
'ColumnWildcard': {
'ExcludedColumnNames': [
'string',
]
}
},
],
}
Response Structure
(dict) --
DataCellsFilters (list) --
A list of DataCellFilter structures.
(dict) --
A structure that describes certain columns on certain rows.
TableCatalogId (string) --
The ID of the catalog to which the table belongs.
DatabaseName (string) --
A database in the Glue Data Catalog.
TableName (string) --
A table in the database.
Name (string) --
The name given by the user to the data filter cell.
RowFilter (dict) --
A PartiQL predicate.
FilterExpression (string) --
A filter expression.
AllRowsWildcard (dict) --
A wildcard for all rows.
ColumnNames (list) --
A list of column names.
ColumnWildcard (dict) --
A wildcard with exclusions.
ExcludedColumnNames (list) --
Excludes column names. Any column with this name will be excluded.
paginator = client.get_paginator('list_lf_tags')
Creates an iterator that will paginate through responses from LakeFormation.Client.list_lf_tags().
See also: AWS API Documentation
Request Syntax
response_iterator = paginator.paginate(
CatalogId='string',
ResourceShareType='FOREIGN'|'ALL',
PaginationConfig={
'MaxItems': 123,
'PageSize': 123,
'StartingToken': 'string'
}
)
A dictionary that provides parameters to control pagination.
The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.
The size of each page.
A token to specify where to start paginating. This is the NextToken from a previous response.
dict
Response Syntax
{
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
}
Response Structure
(dict) --
LFTags (list) --
A list of LF-tags that the requested has permission to view.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
paginator = client.get_paginator('search_databases_by_lf_tags')
Creates an iterator that will paginate through responses from LakeFormation.Client.search_databases_by_lf_tags().
See also: AWS API Documentation
Request Syntax
response_iterator = paginator.paginate(
CatalogId='string',
Expression=[
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
PaginationConfig={
'MaxItems': 123,
'PageSize': 123,
'StartingToken': 'string'
}
)
[REQUIRED]
A list of conditions (LFTag structures) to search for in database resources.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A dictionary that provides parameters to control pagination.
The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.
The size of each page.
A token to specify where to start paginating. This is the NextToken from a previous response.
dict
Response Syntax
{
'DatabaseList': [
{
'Database': {
'CatalogId': 'string',
'Name': 'string'
},
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
},
]
}
Response Structure
(dict) --
DatabaseList (list) --
A list of databases that meet the LF-tag conditions.
(dict) --
A structure describing a database resource with LF-tags.
Database (dict) --
A database that has LF-tags attached to it.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
Name (string) --
The name of the database resource. Unique to the Data Catalog.
LFTags (list) --
A list of LF-tags attached to the database.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
paginator = client.get_paginator('search_tables_by_lf_tags')
Creates an iterator that will paginate through responses from LakeFormation.Client.search_tables_by_lf_tags().
See also: AWS API Documentation
Request Syntax
response_iterator = paginator.paginate(
CatalogId='string',
Expression=[
{
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
PaginationConfig={
'MaxItems': 123,
'PageSize': 123,
'StartingToken': 'string'
}
)
[REQUIRED]
A list of conditions (LFTag structures) to search for in table resources.
A structure that allows an admin to grant user permissions on certain conditions. For example, granting a role access to all columns that do not have the LF-tag 'PII' in tables that have the LF-tag 'Prod'.
The key-name for the LF-tag.
A list of possible values an attribute can take.
A dictionary that provides parameters to control pagination.
The total number of items to return. If the total number of items available is more than the value specified in max-items then a NextToken will be provided in the output that you can use to resume pagination.
The size of each page.
A token to specify where to start paginating. This is the NextToken from a previous response.
dict
Response Syntax
{
'TableList': [
{
'Table': {
'CatalogId': 'string',
'DatabaseName': 'string',
'Name': 'string',
'TableWildcard': {}
},
'LFTagOnDatabase': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'LFTagsOnTable': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
],
'LFTagsOnColumns': [
{
'Name': 'string',
'LFTags': [
{
'CatalogId': 'string',
'TagKey': 'string',
'TagValues': [
'string',
]
},
]
},
]
},
]
}
Response Structure
(dict) --
TableList (list) --
A list of tables that meet the LF-tag conditions.
(dict) --
A structure describing a table resource with LF-tags.
Table (dict) --
A table that has LF-tags attached to it.
CatalogId (string) --
The identifier for the Data Catalog. By default, it is the account ID of the caller.
DatabaseName (string) --
The name of the database for the table. Unique to a Data Catalog. A database is a set of associated table definitions organized into a logical group. You can Grant and Revoke database privileges to a principal.
Name (string) --
The name of the table.
TableWildcard (dict) --
A wildcard object representing every table under a database.
At least one of TableResource$Name or TableResource$TableWildcard is required.
LFTagOnDatabase (list) --
A list of LF-tags attached to the database where the table resides.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagsOnTable (list) --
A list of LF-tags attached to the table.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.
LFTagsOnColumns (list) --
A list of LF-tags attached to columns in the table.
(dict) --
A structure containing the name of a column resource and the LF-tags attached to it.
Name (string) --
The name of a column resource.
LFTags (list) --
The LF-tags attached to a column resource.
(dict) --
A structure containing an LF-tag key-value pair.
CatalogId (string) --
The identifier for the Data Catalog. By default, the account ID. The Data Catalog is the persistent metadata store. It contains database definitions, table definitions, and other control information to manage your Lake Formation environment.
TagKey (string) --
The key-name for the LF-tag.
TagValues (list) --
A list of possible values an attribute can take.