"Parameters" section missing in QuickSight Custom SQL Editor

Q&A
, , ,
1

Hi everyone,

I’m experiencing an issue with Amazon QuickSight in the us-west-2 region. I am trying to create a dataset using Custom SQL against an Oracle database, but the “Parameters” pane is completely missing from the UI.

The Problem: When I open the “Edit Custom SQL” window, the left sidebar (Schema Explorer) shows the Data Source, Schema, and the list of Columns for the selected table, but the “Parameters” section that usually appears below the columns is nowhere to be found.

What I’ve already tried:

  • Manual Syntax: I tried entering WHERE COLUMN = <<$parameter_name>> directly in the code. When I click “Run Query”, it fails with a “General SQL Error” because the parameter hasn’t been defined/created in the QuickSight metadata first.

  • UI Troubleshooting: I’ve checked different browser zoom levels (scaling down to 80%) to see if it was a rendering issue, but the section remains hidden.

  • Permissions: I am logged in with a QuickSight Admin account.

  • Schema Refresh: I’ve tried switching schemas and tables to force a UI refresh, but only the “Columns” list populates; the “Parameters” header never appears.

Can someone help me?

2

Hi @Victor_Endara and welcome to the Quick Community!
I removed your screenshots just in case they included any private information as this is a public facing forum.
There is nothing you’re doing wrong from any standpoint, the issue is that you are utilizing the ‘new data prep experience’. This new data prep version was rolled out to help make a few new features capable, however there are still some features from the old/original data prep experience that are not available yet as they work on combining them.
One of the items is parameters, so if you’re looking to work with parameters at the dataset/data prep level, you’ll need to switch back to the legacy experience (which can be done in the top right corner…however can not be switched once you start editing your dataset).
Here’s some documentation that lays out the features that are still in production/not available yet in the new data prep:

3

Thank you for your answer. It was helpful to me.

1 Like