Value at 'physicalTableMap.<sql_id>.member.customSql.sqlQuery' failed to satisfy constraint: Member must have length less than or equal to 168000

Question & Answer
, ,
1

I am using update_data_Set API of quicksight to update dataset and passing SQL with customSQL parameter.

‘CustomSql’: {
‘DataSourceArn’: data_source_arn,
‘Name’: ‘New custom SQL’,
‘SqlQuery’: new_sql_query,
‘Columns’: [
{‘Name’: ‘id’, ‘Type’: ‘STRING’}
]
}

this new_sql_query has length of 421010 characters.
I have tried manually updating the dataset with same query which is getting successfully updated. But seems we have length limitation for SQL(168000) for API. Anyone experienced the same issue? Any workaround suggestions?

1 Like
2

Hello @Binny, welcome to the QuickSight Community!

This seems to be a limitation linked with the API usage. I looked through the documentation and saw it mentioned as well in the CustomSql information linked to the update_data_set API call.

For this dataset, it seems you will either be required to update it manually within the QuickSight console. Alternatively, you could create a view within your database or find a way to reduce the number of characters in the SQL query.

I can also mark this topic as a feature request since the limitation seems to be only when utilizing the API. Please let me know if you have any further questions on this issue, otherwise I can archive this topic for our support team. Thank you!

2 Likes
3

Hello @Binny, I wanted to check in since we have not heard back from you with any follow-up questions. I have tagged this as a feature-request, but please let me know if I can assist you any further. If we do not hear back from you in 3 days, I will archive this topic for our support team. Thank you!

1 Like
4

Hi @DylanM , you can archive this topic for your support team. Thanks!

1 Like