Skip to content

aws.sagemaker.list_code_repositories

Example SQL Queries

SELECT * FROM
aws.sagemaker.list_code_repositories;

Description

Gets a list of the Git repositories in your account.

Table Definition

Column NameColumn Data Type
creation_time_after Input Column

A filter that returns only Git repositories that were created after the specified time.

TIMESTAMP_S
creation_time_before Input Column

A filter that returns only Git repositories that were created before the specified time.

TIMESTAMP_S
last_modified_time_after Input Column

A filter that returns only Git repositories that were last modified after the specified time.

TIMESTAMP_S
last_modified_time_before Input Column

A filter that returns only Git repositories that were last modified before the specified time.

TIMESTAMP_S
name_contains Input Column

A string in the Git repositories name. This filter returns only repositories whose name contains the specified string.

VARCHAR
sort_by Input Column

The field to sort results by. The default is Name.

VARCHAR
sort_order Input Column

The sort order for results. The default is Ascending.

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.

code_repository_arn

The Amazon Resource Name (ARN) of the Git repository.

VARCHAR
code_repository_name

The name of the Git repository.

VARCHAR
creation_time

The date and time that the Git repository was created.

TIMESTAMP_S
git_config

Configuration details for the Git repository, including the URL where it is located and the ARN of the Amazon Web Services Secrets Manager secret that contains the credentials used to access the repository.

STRUCT(
"repository_url" VARCHAR,
"branch" VARCHAR,
"secret_arn" VARCHAR
)
Show child fields
git_config.branch

The default branch for the Git repository.

git_config.repository_url

The URL where the Git repository is located.

git_config.secret_arn

The Amazon Resource Name (ARN) of the Amazon Web Services Secrets Manager secret that contains the credentials used to access the git repository. The secret must have a staging label of AWSCURRENT and must be in the following format:

{"username": UserName, "password": Password}

last_modified_time

The date and time that the Git repository was last modified.

TIMESTAMP_S