| Column Name | Column Data Type |
|---|
filters Input Column
If you specify any of the following filters, the output includes information for only those schemas that meet the filter criteria: -
complexity – The schema's complexity, for example Simple. -
database-id – The ID of the schema's database. -
database-ip-address – The IP address of the schema's database. -
database-name – The name of the schema's database. -
database-engine – The name of the schema database's engine. -
original-schema-name – The name of the schema's database's main schema. -
schema-id – The ID of the schema, for example 15. -
schema-name – The name of the schema. -
server-ip-address – The IP address of the schema database's server. An example is: describe-fleet-advisor-schemas --filter Name="schema-id",Values="50" | STRUCT(
"name" VARCHAR,
"values" VARCHAR[]
)[] |
Show child fields- filters[]
Show child fields- filters[].name
The name of the filter as specified for a Describe* or similar operation. - filters[].values[]
|
max_records Input Column
Sets the maximum number of records returned in the response. | BIGINT |
next_token Input Column
If NextToken is returned, there are more results available. The value of NextToken is a unique pagination token for each page. Make the call again using the returned token to retrieve the next page. Keep all other arguments unchanged. | VARCHAR |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
_aws_region Input Column
The AWS region to use. | VARCHAR |
fleet_advisor_schemas
A collection of SchemaResponse objects. | STRUCT(
"code_line_count" BIGINT,
"code_size" BIGINT,
"complexity" VARCHAR,
"server" STRUCT(
"server_id" VARCHAR,
"ip_address" VARCHAR,
"server_name" VARCHAR
),
"database_instance" STRUCT(
"database_id" VARCHAR,
"database_name" VARCHAR,
"database_ip_address" VARCHAR,
"database_engine" VARCHAR
),
"schema_id" VARCHAR,
"schema_name" VARCHAR,
"original_schema" STRUCT(
"schema_id" VARCHAR,
"schema_name" VARCHAR,
"database_id" VARCHAR,
"database_name" VARCHAR,
"database_ip_address" VARCHAR
),
"similarity" DOUBLE
)[] |
Show child fields- fleet_advisor_schemas[]
Show child fields- fleet_advisor_schemas[].code_line_count
The number of lines of code in a schema in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].code_size
The size level of the code in a schema in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].complexity
The complexity level of the code in a schema in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].database_instance
The database for a schema in a Fleet Advisor collector inventory. Show child fields- fleet_advisor_schemas[].database_instance.database_engine
The database engine of a database in a Fleet Advisor collector inventory, for example PostgreSQL. - fleet_advisor_schemas[].database_instance.database_id
The ID of a database in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].database_instance.database_ip_address
The IP address of a database in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].database_instance.database_name
The name of a database in a Fleet Advisor collector inventory.
- fleet_advisor_schemas[].original_schema
Describes a schema in a Fleet Advisor collector inventory. Show child fields- fleet_advisor_schemas[].original_schema.database_id
The ID of a database in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].original_schema.database_ip_address
The IP address of a database in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].original_schema.database_name
The name of a database in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].original_schema.schema_id
The ID of a schema in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].original_schema.schema_name
The name of a schema in a Fleet Advisor collector inventory.
- fleet_advisor_schemas[].schema_id
The ID of a schema in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].schema_name
The name of a schema in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].server
The database server for a schema in a Fleet Advisor collector inventory. Show child fields- fleet_advisor_schemas[].server.ip_address
The IP address of a server in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].server.server_id
The ID of a server in a Fleet Advisor collector inventory. - fleet_advisor_schemas[].server.server_name
The name address of a server in a Fleet Advisor collector inventory.
- fleet_advisor_schemas[].similarity
The similarity value for a schema in a Fleet Advisor collector inventory. A higher similarity value indicates that a schema is likely to be a duplicate.
|