Skip to content

aws.chime_sdk_meetings.get_meeting

Example SQL Queries

SELECT * FROM
aws.chime_sdk_meetings.get_meeting
WHERE
"meeting_id" = 'VALUE';

Description

Gets the Amazon Chime SDK meeting details for the specified meeting ID. For more information about the Amazon Chime SDK, see Using the Amazon Chime SDK in the Amazon Chime Developer Guide.

Table Definition

Column NameColumn Data Type
meeting_id Required Input Column

The Amazon Chime SDK meeting ID.

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.

meeting

The Amazon Chime SDK meeting information.

STRUCT(
"meeting_id" VARCHAR,
"meeting_host_id" VARCHAR,
"external_meeting_id" VARCHAR,
"media_region" VARCHAR,
"media_placement" STRUCT(
"audio_host_url" VARCHAR,
"audio_fallback_url" VARCHAR,
"signaling_url" VARCHAR,
"turn_control_url" VARCHAR,
"screen_data_url" VARCHAR,
"screen_viewing_url" VARCHAR,
"screen_sharing_url" VARCHAR,
"event_ingestion_url" VARCHAR
),
"meeting_features" STRUCT(
"audio" STRUCT(
"echo_reduction" VARCHAR
),
"video" STRUCT(
"max_resolution" VARCHAR
),
"content" STRUCT(
"max_resolution" VARCHAR
),
"attendee" STRUCT(
"max_count" BIGINT
)
),
"primary_meeting_id" VARCHAR,
"tenant_ids" VARCHAR[],
"meeting_arn" VARCHAR
)
Show child fields
meeting.external_meeting_id

The external meeting ID.

Pattern: [-_&@+=,(){}\[\]\/«».:|'"#a-zA-Z0-9À-ÿ\s]*

Values that begin with aws: are reserved. You can't configure a value that uses this prefix. Case insensitive.

meeting.media_placement

The media placement for the meeting.

Show child fields
meeting.media_placement.audio_fallback_url

The audio fallback URL.

meeting.media_placement.audio_host_url

The audio host URL.

meeting.media_placement.event_ingestion_url

The event ingestion URL.

meeting.media_placement.screen_data_url

The screen data URL.

This parameter is deprecated and no longer used by the Amazon Chime SDK.

meeting.media_placement.screen_sharing_url

The screen sharing URL.

This parameter is deprecated and no longer used by the Amazon Chime SDK.

meeting.media_placement.screen_viewing_url

The screen viewing URL.

This parameter is deprecated and no longer used by the Amazon Chime SDK.

meeting.media_placement.signaling_url

The signaling URL.

meeting.media_placement.turn_control_url

The turn control URL.

This parameter is deprecated and no longer used by the Amazon Chime SDK.

meeting.media_region

The Region in which you create the meeting. Available values: af-south-1, ap-northeast-1, ap-northeast-2, ap-south-1, ap-southeast-1, ap-southeast-2, ca-central-1, eu-central-1, eu-north-1, eu-south-1, eu-west-1, eu-west-2, eu-west-3, sa-east-1, us-east-1, us-east-2, us-west-1, us-west-2.

Available values in Amazon Web Services GovCloud (US) Regions: us-gov-east-1, us-gov-west-1.

meeting.meeting_arn

The ARN of the meeting.

meeting.meeting_features

The features available to a meeting, such as echo reduction.

Show child fields
meeting.meeting_features.attendee

The configuration settings for the attendee features available to a meeting.

Show child fields
meeting.meeting_features.attendee.max_count

The maximum number of attendees allowed into the meeting.

meeting.meeting_features.audio

The configuration settings for the audio features available to a meeting.

Show child fields
meeting.meeting_features.audio.echo_reduction

Makes echo reduction available to clients who connect to the meeting.

meeting.meeting_features.content

The configuration settings for the content features available to a meeting.

Show child fields
meeting.meeting_features.content.max_resolution

The maximum resolution for the meeting content.

Defaults to FHD. To use UHD, you must also provide a MeetingFeatures:Attendee:MaxCount value and override the default size limit of 250 attendees.

meeting.meeting_features.video

The configuration settings for the video features available to a meeting.

Show child fields
meeting.meeting_features.video.max_resolution

The maximum video resolution for the meeting. Applies to all attendees.

Defaults to HD. To use FHD, you must also provide a MeetingFeatures:Attendee:MaxCount value and override the default size limit of 250 attendees.

meeting.meeting_host_id

Reserved.

meeting.meeting_id

The Amazon Chime SDK meeting ID.

meeting.primary_meeting_id

When specified, replicates the media from the primary meeting to this meeting.

meeting.tenant_ids[]