How to use Quicksight API to create ingestion for dataset using lambda function?

Question & Answer
, ,
1

I have a dataset in one AWS account that I am trying to create ingestion using Quicksight API call. The dataset is sourced from s3 bucket file in another AWS account. I have created a lambda function in the AWS account same as the s3 data source. This lambda function is triggered whenever a new file is uploaded in the s3 bucket. The problem is that I am unable to call the create ingestion method from the lambda function. I am getting this error. CreateIngestion operation: Account information not found for AccountID: (my s3 account ID).

2

You need to ingest the quicksight dataset. Not the s3 information.

https://docs.aws.amazon.com/cli/latest/reference/quicksight/create-ingestion.html

You need to pass in dataset id, aws account id, and an id for the ingestion id (could be unix time) or something unique

3

Hi Max, Apologies for not making it clear. I am using the AWS account information.
See below code -
qs = boto3.client(‘quicksight’)
response = qs.create_ingestion(
DataSetId=‘xxxxxxxxx’,
IngestionId=‘uniqueid’,
AwsAccountId=‘Account B’,
IngestionType=‘FULL_REFRESH’
)

The issue is that the error I am getting is that CreateIngestion operation: AWS Account B information not found for AccountID: AWS Account A

I am calling the API from different AWS Account. Is there a way I can connect the two accounts?

4

Please check out these blogs.

1 Like
5

Abhishek, use the account id number versus account id alias.

6

@Max @n_vetri

The CreateIngestion API limit of 32, is it for each dataset or at enterprise account level?
Further, is this limit adjustable?