Custom SQL not working

Options
Renny.L.790
Renny.L.790 Posts: 2 🌱

Hi,

I am facing difficulties with Analytics Builder Custom SQL.

I am asked by my rep to access and find a place to submit a Support Ticket, but is unable to find where to do it.

Can anyone assist to guide how can I submit a support ticket as I am unable to do any Data Modelling without the custom SQL feature in QuickSights.

If there are any custom SQL formats which is required, so let us know some examples so we can proceed with data modeling for Analytics Builder.

region:
timestamp:
requestld:
sourceErrorCode:

sourceErrorMessage:

sourceErrorState:
sourceException:
sourceType:

ap-southeast-1
1715054250061
1338317d-c1ac-4990-8b9d-1453ad8ac0d3
100071
[Simba]AthenaJDBC An error has been thrown
from the AWS Athena client. Insufficient permissions to
execute the query. User:
arn:aws:sts :: 851725282471:assumed-role/run-as-
7082f469-4720-4965-afa2-7f6187b4b670/QuickSight-
RoleSession-1715054249054 is not authorized to perform:
glue:GetDatabase on resource: arn:aws:glue:ap-southeast-
1:851725282471:database/default because no identity-
based policy allows the glue:GetDatabase action [Execution
ID: b9b2df71-49d0-4954-8e16-a0f53286f1fa]
HY000
java.sql.SQLException
ATHENA

Best Answer

  • Prithvi.A.303
    Prithvi.A.303 Posts: 38
    Answer ✓
    Options

    Hello @Renny.L.790

    Thanks for contacting us via Brightspace community!

    If you are listed as an organization's Approved Support Contact (ASC), please access the Community's ASC homepage to open a support case with our Product Support Team.

    You can find the ASC Homepage under Quick Links on the right side of your screen:

    You can find further instructions on how to submit a service request in the following article:

    https://community.d2l.com/brightspace/kb/articles/1175-approved-support-contacts-create-a-case-or-service-request

    If you are not listed as an ASC may I request you to contact your Accounts Team (CSM/TAM).

    Regarding custom SQL formats, May I request you to submit a support case as it might require additional testing.

    Thanks & Regards,

    Prithvi