data_sources

Creates, updates, deletes, gets or lists a data_sources resource.

Overview

Name	data_sources
Type	Resource
Id	aws.quicksight.data_sources

Fields

The following fields are returned by SELECT queries:

describe_data_source

Name	Datatype	Description
data_source	object	The structure of a data source.
request_id	string	The Amazon Web Services request ID for this operation.
status	integer	The HTTP status of the request.

search_data_sources

Name	Datatype	Description
arn	string	The arn of the datasource.
created_time	string (date-time)	The date and time that the data source was created. This value is expressed in MM-DD-YYYY HH:MM:SS format.
data_source_id	string	The unique ID of the data source.
last_updated_time	string (date-time)	The date and time the data source was last updated. This value is expressed in MM-DD-YYYY HH:MM:SS format.
name	string	The name of the data source.
type	string	The type of the data source. (ADOBE_ANALYTICS, AMAZON_ELASTICSEARCH, ATHENA, AURORA, AURORA_POSTGRESQL, AWS_IOT_ANALYTICS, GITHUB, JIRA, MARIADB, MYSQL, ORACLE, POSTGRESQL, PRESTO, REDSHIFT, S3, S3_TABLES, SALESFORCE, SERVICENOW, SNOWFLAKE, SPARK, SQLSERVER, TERADATA, TWITTER, TIMESTREAM, AMAZON_OPENSEARCH, EXASOL, DATABRICKS, STARBURST, TRINO, BIGQUERY, GOOGLESHEETS, GOOGLE_DRIVE, CONFLUENCE, SHAREPOINT, ONE_DRIVE, WEB_CRAWLER, S3_KNOWLEDGE_BASE, QBUSINESS)

list_data_sources

Name	Datatype	Description
alternate_data_source_parameters	array	A set of alternate data source parameters that you want to share for the credentials stored with this data source. The credentials are applied in tandem with the data source parameters when you copy a data source by using a create or update request. The API operation compares the DataSourceParameters structure that's in the request with the structures in the AlternateDataSourceParameters allow list. If the structures are an exact match, the request is allowed to use the credentials from this existing data source. If the AlternateDataSourceParameters list is null, the Credentials originally used with this DataSourceParameters are automatically allowed.
arn	string	The Amazon Resource Name (ARN) of the data source.
created_time	string (date-time)	The time that this data source was created.
credential_status	string	The credential verification status of the data source. Valid values include: CONNECTED – Credential validation succeeded. AUTH_FAILED – Credential validation failed. NOT_VERIFIED – Credential validation has not been performed. (CONNECTED, AUTH_FAILED, NOT_VERIFIED)
data_source_id	string	The ID of the data source. This ID is unique per Amazon Web Services Region for each Amazon Web Services account.
data_source_parameters	object	The parameters that Quick Sight uses to connect to your underlying data source. This is a variant type structure. For this structure to be valid, only one of the attributes can be non-null.
error_info	object	Error information from the last update or the creation of the data source.
last_credential_verified_at	string (date-time)	The time that the credentials were last verified.
last_updated_time	string (date-time)	The last time that this data source was updated.
name	string	A display name for the data source.
secret_arn	string	The Amazon Resource Name (ARN) of the secret associated with the data source in Amazon Secrets Manager. (pattern: <code>^arn:[-a-z0-9]:secretsmanager:[-a-z0-9]:[0-9]{12}㊙️.+</code>)
ssl_properties	object	Secure Socket Layer (SSL) properties that apply when Quick Sight connects to your underlying data source.
status	string	The HTTP status of the request. (CREATION_IN_PROGRESS, CREATION_SUCCESSFUL, CREATION_FAILED, UPDATE_IN_PROGRESS, UPDATE_SUCCESSFUL, UPDATE_FAILED, DELETED)
type	string	The type of the data source. This type indicates which database engine the data source connects to. (ADOBE_ANALYTICS, AMAZON_ELASTICSEARCH, ATHENA, AURORA, AURORA_POSTGRESQL, AWS_IOT_ANALYTICS, GITHUB, JIRA, MARIADB, MYSQL, ORACLE, POSTGRESQL, PRESTO, REDSHIFT, S3, S3_TABLES, SALESFORCE, SERVICENOW, SNOWFLAKE, SPARK, SQLSERVER, TERADATA, TWITTER, TIMESTREAM, AMAZON_OPENSEARCH, EXASOL, DATABRICKS, STARBURST, TRINO, BIGQUERY, GOOGLESHEETS, GOOGLE_DRIVE, CONFLUENCE, SHAREPOINT, ONE_DRIVE, WEB_CRAWLER, S3_KNOWLEDGE_BASE, QBUSINESS)
vpc_connection_properties	object	VPC connection properties.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
describe_data_source	select	aws_account_id, data_source_id, region		Describes a data source.
search_data_sources	select	aws_account_id, region		Use the SearchDataSources operation to search for data sources that belong to an account.
list_data_sources	select	aws_account_id, region	next-token, max-results	Lists data sources in current Amazon Web Services Region that belong to this Amazon Web Services account.
create_data_source	insert	aws_account_id, region, DataSourceId		Creates a data source.
update_data_source	update	aws_account_id, data_source_id, region		Updates a data source.
delete_data_source	delete	aws_account_id, data_source_id, region		Deletes the data source permanently. This operation breaks all the datasets that reference the deleted data source.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
aws_account_id	string	The Amazon Web Services account ID.
data_source_id	string	The ID of the data source. This ID is unique per Amazon Web Services Region for each Amazon Web Services account.
region	string	AWS region (default: us-east-1)
max-results	integer	The maximum number of results to be returned per request.
next-token	string	The token for the next set of results, or null if there are no more results.

SELECT examples

describe_data_source

Describes a data source.

SELECT
data_source,
request_id,
status
FROM aws.quicksight.data_sources
WHERE aws_account_id = '{{ aws_account_id }}' -- required
AND data_source_id = '{{ data_source_id }}' -- required
AND region = '{{ region }}' -- required
;

search_data_sources

Use the SearchDataSources operation to search for data sources that belong to an account.

SELECT
arn,
created_time,
data_source_id,
last_updated_time,
name,
type
FROM aws.quicksight.data_sources
WHERE aws_account_id = '{{ aws_account_id }}' -- required
AND region = '{{ region }}' -- required
;

list_data_sources

Lists data sources in current Amazon Web Services Region that belong to this Amazon Web Services account.

SELECT
alternate_data_source_parameters,
arn,
created_time,
credential_status,
data_source_id,
data_source_parameters,
error_info,
last_credential_verified_at,
last_updated_time,
name,
secret_arn,
ssl_properties,
status,
type,
vpc_connection_properties
FROM aws.quicksight.data_sources
WHERE aws_account_id = '{{ aws_account_id }}' -- required
AND region = '{{ region }}' -- required
AND `next-token` = '{{ next-token }}'
AND `max-results` = '{{ max-results }}'
;

INSERT examples

create_data_source

Creates a data source.

INSERT INTO aws.quicksight.data_sources (
DataSourceId,
Name,
Type,
DataSourceParameters,
Credentials,
Permissions,
VpcConnectionProperties,
SslProperties,
Tags,
FolderArns,
aws_account_id,
region
)
SELECT 
'{{ DataSourceId }}' /* required */,
'{{ Name }}',
'{{ Type }}',
'{{ DataSourceParameters }}',
'{{ Credentials }}',
'{{ Permissions }}',
'{{ VpcConnectionProperties }}',
'{{ SslProperties }}',
'{{ Tags }}',
'{{ FolderArns }}',
'{{ aws_account_id }}',
'{{ region }}'
RETURNING
arn,
creation_status,
data_source_id,
request_id,
status
;

Manifest

# Description fields are for documentation purposes
- name: data_sources
props:
  - name: aws_account_id
    value: "{{ aws_account_id }}"
    description: Required parameter for the data_sources resource.
  - name: region
    value: "{{ region }}"
    description: Required parameter for the data_sources resource.
  - name: DataSourceId
    value: "{{ DataSourceId }}"
  - name: Name
    value: "{{ Name }}"
  - name: Type
    value: "{{ Type }}"
    valid_values: ['ADOBE_ANALYTICS', 'AMAZON_ELASTICSEARCH', 'ATHENA', 'AURORA', 'AURORA_POSTGRESQL', 'AWS_IOT_ANALYTICS', 'GITHUB', 'JIRA', 'MARIADB', 'MYSQL', 'ORACLE', 'POSTGRESQL', 'PRESTO', 'REDSHIFT', 'S3', 'S3_TABLES', 'SALESFORCE', 'SERVICENOW', 'SNOWFLAKE', 'SPARK', 'SQLSERVER', 'TERADATA', 'TWITTER', 'TIMESTREAM', 'AMAZON_OPENSEARCH', 'EXASOL', 'DATABRICKS', 'STARBURST', 'TRINO', 'BIGQUERY', 'GOOGLESHEETS', 'GOOGLE_DRIVE', 'CONFLUENCE', 'SHAREPOINT', 'ONE_DRIVE', 'WEB_CRAWLER', 'S3_KNOWLEDGE_BASE', 'QBUSINESS']
  - name: DataSourceParameters
    description: |
      The parameters that Quick Sight uses to connect to your underlying data source. This is a variant type structure. For this structure to be valid, only one of the attributes can be non-null.
    value:
      AmazonElasticsearchParameters:
        Domain: "{{ Domain }}"
      AthenaParameters:
        WorkGroup: "{{ WorkGroup }}"
        RoleArn: "{{ RoleArn }}"
        ConsumerAccountRoleArn: "{{ ConsumerAccountRoleArn }}"
        IdentityCenterConfiguration:
          EnableIdentityPropagation: {{ EnableIdentityPropagation }}
      AuroraParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      AuroraPostgreSqlParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      AwsIotAnalyticsParameters:
        DataSetName: "{{ DataSetName }}"
      JiraParameters:
        SiteBaseUrl: "{{ SiteBaseUrl }}"
      MariaDbParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      MySqlParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      OracleParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
        UseServiceName: {{ UseServiceName }}
      PostgreSqlParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      PrestoParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Catalog: "{{ Catalog }}"
      RdsParameters:
        InstanceId: "{{ InstanceId }}"
        Database: "{{ Database }}"
      RedshiftParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
        ClusterId: "{{ ClusterId }}"
        IAMParameters:
          RoleArn: "{{ RoleArn }}"
          DatabaseUser: "{{ DatabaseUser }}"
          DatabaseGroups:
            - "{{ DatabaseGroups }}"
          AutoCreateDatabaseUser: {{ AutoCreateDatabaseUser }}
        IdentityCenterConfiguration:
          EnableIdentityPropagation: {{ EnableIdentityPropagation }}
      S3Parameters:
        ManifestFileLocation:
          Bucket: "{{ Bucket }}"
          Key: "{{ Key }}"
        RoleArn: "{{ RoleArn }}"
      S3TablesParameters:
        TableBucketArn: "{{ TableBucketArn }}"
      S3KnowledgeBaseParameters:
        RoleArn: "{{ RoleArn }}"
        BucketUrl: "{{ BucketUrl }}"
        MetadataFilesLocation: "{{ MetadataFilesLocation }}"
      ServiceNowParameters:
        SiteBaseUrl: "{{ SiteBaseUrl }}"
      SnowflakeParameters:
        Host: "{{ Host }}"
        Database: "{{ Database }}"
        Warehouse: "{{ Warehouse }}"
        AuthenticationType: "{{ AuthenticationType }}"
        DatabaseAccessControlRole: "{{ DatabaseAccessControlRole }}"
        OAuthParameters:
          TokenProviderUrl: "{{ TokenProviderUrl }}"
          OAuthScope: "{{ OAuthScope }}"
          IdentityProviderVpcConnectionProperties:
            VpcConnectionArn: "{{ VpcConnectionArn }}"
          IdentityProviderResourceUri: "{{ IdentityProviderResourceUri }}"
          IdentityProviderCACertificatesBundleS3Uri: "{{ IdentityProviderCACertificatesBundleS3Uri }}"
      SparkParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
      SqlServerParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      TeradataParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
      TwitterParameters:
        Query: "{{ Query }}"
        MaxRows: {{ MaxRows }}
      AmazonOpenSearchParameters:
        Domain: "{{ Domain }}"
      ExasolParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
      DatabricksParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        SqlEndpointPath: "{{ SqlEndpointPath }}"
      StarburstParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Catalog: "{{ Catalog }}"
        ProductType: "{{ ProductType }}"
        DatabaseAccessControlRole: "{{ DatabaseAccessControlRole }}"
        AuthenticationType: "{{ AuthenticationType }}"
        OAuthParameters:
          TokenProviderUrl: "{{ TokenProviderUrl }}"
          OAuthScope: "{{ OAuthScope }}"
          IdentityProviderVpcConnectionProperties:
            VpcConnectionArn: "{{ VpcConnectionArn }}"
          IdentityProviderResourceUri: "{{ IdentityProviderResourceUri }}"
          IdentityProviderCACertificatesBundleS3Uri: "{{ IdentityProviderCACertificatesBundleS3Uri }}"
      TrinoParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Catalog: "{{ Catalog }}"
      BigQueryParameters:
        ProjectId: "{{ ProjectId }}"
        DataSetRegion: "{{ DataSetRegion }}"
      ImpalaParameters:
        Host: "{{ Host }}"
        Port: {{ Port }}
        Database: "{{ Database }}"
        SqlEndpointPath: "{{ SqlEndpointPath }}"
      CustomConnectionParameters:
        ConnectionType: "{{ ConnectionType }}"
      WebCrawlerParameters:
        WebCrawlerAuthType: "{{ WebCrawlerAuthType }}"
        UsernameFieldXpath: "{{ UsernameFieldXpath }}"
        PasswordFieldXpath: "{{ PasswordFieldXpath }}"
        UsernameButtonXpath: "{{ UsernameButtonXpath }}"
        PasswordButtonXpath: "{{ PasswordButtonXpath }}"
        LoginPageUrl: "{{ LoginPageUrl }}"
        WebProxyHostName: "{{ WebProxyHostName }}"
        WebProxyPortNumber: {{ WebProxyPortNumber }}
      ConfluenceParameters:
        ConfluenceUrl: "{{ ConfluenceUrl }}"
      QBusinessParameters:
        ApplicationArn: "{{ ApplicationArn }}"
      SharePointParameters:
        SharePointDomain: "{{ SharePointDomain }}"
        TenantId: "{{ TenantId }}"
        ClientId: "{{ ClientId }}"
        AuthType: "{{ AuthType }}"
      GoogleDriveParameters:
        AuthType: "{{ AuthType }}"
      OneDriveParameters:
        TenantId: "{{ TenantId }}"
        ClientId: "{{ ClientId }}"
        AuthType: "{{ AuthType }}"
      FMKBParameters:
        KnowledgeBaseArn: "{{ KnowledgeBaseArn }}"
        LinkedDataSourceIds:
          - "{{ LinkedDataSourceIds }}"
  - name: Credentials
    description: |
      Data source credentials. This is a variant type structure. For this structure to be valid, only one of the attributes can be non-null.
    value:
      CredentialPair:
        Username: "{{ Username }}"
        Password: "{{ Password }}"
        AlternateDataSourceParameters:
          - AmazonElasticsearchParameters:
              Domain: "{{ Domain }}"
            AthenaParameters:
              WorkGroup: "{{ WorkGroup }}"
              RoleArn: "{{ RoleArn }}"
              ConsumerAccountRoleArn: "{{ ConsumerAccountRoleArn }}"
              IdentityCenterConfiguration:
                EnableIdentityPropagation: {{ EnableIdentityPropagation }}
            AuroraParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            AuroraPostgreSqlParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            AwsIotAnalyticsParameters:
              DataSetName: "{{ DataSetName }}"
            JiraParameters:
              SiteBaseUrl: "{{ SiteBaseUrl }}"
            MariaDbParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            MySqlParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            OracleParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
              UseServiceName: {{ UseServiceName }}
            PostgreSqlParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            PrestoParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Catalog: "{{ Catalog }}"
            RdsParameters:
              InstanceId: "{{ InstanceId }}"
              Database: "{{ Database }}"
            RedshiftParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
              ClusterId: "{{ ClusterId }}"
              IAMParameters:
                RoleArn: "{{ RoleArn }}"
                DatabaseUser: "{{ DatabaseUser }}"
                DatabaseGroups: "{{ DatabaseGroups }}"
                AutoCreateDatabaseUser: {{ AutoCreateDatabaseUser }}
              IdentityCenterConfiguration:
                EnableIdentityPropagation: {{ EnableIdentityPropagation }}
            S3Parameters:
              ManifestFileLocation:
                Bucket: "{{ Bucket }}"
                Key: "{{ Key }}"
              RoleArn: "{{ RoleArn }}"
            S3TablesParameters:
              TableBucketArn: "{{ TableBucketArn }}"
            S3KnowledgeBaseParameters:
              RoleArn: "{{ RoleArn }}"
              BucketUrl: "{{ BucketUrl }}"
              MetadataFilesLocation: "{{ MetadataFilesLocation }}"
            ServiceNowParameters:
              SiteBaseUrl: "{{ SiteBaseUrl }}"
            SnowflakeParameters:
              Host: "{{ Host }}"
              Database: "{{ Database }}"
              Warehouse: "{{ Warehouse }}"
              AuthenticationType: "{{ AuthenticationType }}"
              DatabaseAccessControlRole: "{{ DatabaseAccessControlRole }}"
              OAuthParameters:
                TokenProviderUrl: "{{ TokenProviderUrl }}"
                OAuthScope: "{{ OAuthScope }}"
                IdentityProviderVpcConnectionProperties: "{{ IdentityProviderVpcConnectionProperties }}"
                IdentityProviderResourceUri: "{{ IdentityProviderResourceUri }}"
                IdentityProviderCACertificatesBundleS3Uri: "{{ IdentityProviderCACertificatesBundleS3Uri }}"
            SparkParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
            SqlServerParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            TeradataParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
            TwitterParameters:
              Query: "{{ Query }}"
              MaxRows: {{ MaxRows }}
            AmazonOpenSearchParameters:
              Domain: "{{ Domain }}"
            ExasolParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
            DatabricksParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              SqlEndpointPath: "{{ SqlEndpointPath }}"
            StarburstParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Catalog: "{{ Catalog }}"
              ProductType: "{{ ProductType }}"
              DatabaseAccessControlRole: "{{ DatabaseAccessControlRole }}"
              AuthenticationType: "{{ AuthenticationType }}"
              OAuthParameters:
                TokenProviderUrl: "{{ TokenProviderUrl }}"
                OAuthScope: "{{ OAuthScope }}"
                IdentityProviderVpcConnectionProperties: "{{ IdentityProviderVpcConnectionProperties }}"
                IdentityProviderResourceUri: "{{ IdentityProviderResourceUri }}"
                IdentityProviderCACertificatesBundleS3Uri: "{{ IdentityProviderCACertificatesBundleS3Uri }}"
            TrinoParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Catalog: "{{ Catalog }}"
            BigQueryParameters:
              ProjectId: "{{ ProjectId }}"
              DataSetRegion: "{{ DataSetRegion }}"
            ImpalaParameters:
              Host: "{{ Host }}"
              Port: {{ Port }}
              Database: "{{ Database }}"
              SqlEndpointPath: "{{ SqlEndpointPath }}"
            CustomConnectionParameters:
              ConnectionType: "{{ ConnectionType }}"
            WebCrawlerParameters:
              WebCrawlerAuthType: "{{ WebCrawlerAuthType }}"
              UsernameFieldXpath: "{{ UsernameFieldXpath }}"
              PasswordFieldXpath: "{{ PasswordFieldXpath }}"
              UsernameButtonXpath: "{{ UsernameButtonXpath }}"
              PasswordButtonXpath: "{{ PasswordButtonXpath }}"
              LoginPageUrl: "{{ LoginPageUrl }}"
              WebProxyHostName: "{{ WebProxyHostName }}"
              WebProxyPortNumber: {{ WebProxyPortNumber }}
            ConfluenceParameters:
              ConfluenceUrl: "{{ ConfluenceUrl }}"
            QBusinessParameters:
              ApplicationArn: "{{ ApplicationArn }}"
            SharePointParameters:
              SharePointDomain: "{{ SharePointDomain }}"
              TenantId: "{{ TenantId }}"
              ClientId: "{{ ClientId }}"
              AuthType: "{{ AuthType }}"
            GoogleDriveParameters:
              AuthType: "{{ AuthType }}"
            OneDriveParameters:
              TenantId: "{{ TenantId }}"
              ClientId: "{{ ClientId }}"
              AuthType: "{{ AuthType }}"
            FMKBParameters:
              KnowledgeBaseArn: "{{ KnowledgeBaseArn }}"
              LinkedDataSourceIds:
                - "{{ LinkedDataSourceIds }}"
      CopySourceArn: "{{ CopySourceArn }}"
      SecretArn: "{{ SecretArn }}"
      KeyPairCredentials:
        KeyPairUsername: "{{ KeyPairUsername }}"
        PrivateKey: "{{ PrivateKey }}"
        PrivateKeyPassphrase: "{{ PrivateKeyPassphrase }}"
      WebProxyCredentials:
        WebProxyUsername: "{{ WebProxyUsername }}"
        WebProxyPassword: "{{ WebProxyPassword }}"
      OAuthClientCredentials:
        ClientId: "{{ ClientId }}"
        ClientSecret: "{{ ClientSecret }}"
        Username: "{{ Username }}"
  - name: Permissions
    value:
      - Principal: "{{ Principal }}"
        Actions: "{{ Actions }}"
  - name: VpcConnectionProperties
    description: |
      VPC connection properties.
    value:
      VpcConnectionArn: "{{ VpcConnectionArn }}"
  - name: SslProperties
    description: |
      Secure Socket Layer (SSL) properties that apply when Quick Sight connects to your underlying data source.
    value:
      DisableSsl: {{ DisableSsl }}
  - name: Tags
    value:
      - Key: "{{ Key }}"
        Value: "{{ Value }}"
  - name: FolderArns
    value:
      - "{{ FolderArns }}"

UPDATE examples

update_data_source

Updates a data source.

UPDATE aws.quicksight.data_sources
SET 
Name = '{{ Name }}',
DataSourceParameters = '{{ DataSourceParameters }}',
Credentials = '{{ Credentials }}',
VpcConnectionProperties = '{{ VpcConnectionProperties }}',
SslProperties = '{{ SslProperties }}'
WHERE 
aws_account_id = '{{ aws_account_id }}' --required
AND data_source_id = '{{ data_source_id }}' --required
AND region = '{{ region }}' --required
RETURNING
arn,
data_source_id,
request_id,
status,
update_status;

DELETE examples

delete_data_source

Deletes the data source permanently. This operation breaks all the datasets that reference the deleted data source.

DELETE FROM aws.quicksight.data_sources
WHERE aws_account_id = '{{ aws_account_id }}' --required
AND data_source_id = '{{ data_source_id }}' --required
AND region = '{{ region }}' --required
;