How to get physical table Id for custom sql when using boto3 create_data_set API call

[manishpadmajan]

Hi EveryOne,

I am using Custom SQL option in boto3 create_data_set API call. I want to transform one of the column to new DATETIME format. As per the documentation, in LogicalTableMap, I have to pass PhysicalTableId value. I am not sure how to get this value. Even describe data set does not mention any physical table id.
How can I get physical table Id for a physical table built using custom sql?

Thank you,

with rgds,
Manish

[WLS-D]

Hello @manishpadmajan , welcome to the Quicksight community!

Have you tried the solution provided here?:

How to get physical table id quicksight data set boto3 create_data_set API call

I’m creating a data set using the create_data_set API call in boto3. In the LogicalTableMap Property, we have to mention a ‘Source’ which is the id of the ‘PhysicalTable’. How do I extract the physical Table id of a data set that I’m just creating with this same API call? Thanks!

[WLS-D]

Hello @manishpadmajan !

I have marked this as a solution for now. Please let me know if you need additional help with this problem!