Creating dataset using custom sql query with table name starting with number

Question & Answer
, ,
1

I am trying to create a dataset using a custom sql query.

Example query:
select userid FROM "db_name.5uhnoy9evxv8eqlbufzm7f"

Since the table name starts with a number 5, I am getting following exception while adding dataset.
image

Following query in athena sql editor works fine
select userid FROM "5uhnoy9evxv8eqlbufzm7f"

How can I add the dataset using the query? Thanks in advance.

2

Since I am new to use SQL and quicksight, failed to see this easy solution. It works like this select userid FROM "db_name"."5uhnoy9evxv8eqlbufzm7f"